Author: Kepion Product Team
You can transfer an Application between environments by backing up and restoring it to your SQL Server. This guide will cover the backup and restoration processes. But before we begin, we'll explain what each process entails.
Back up Database: The process of generating a .bak file that represents all the data, structures and logic within an Application database. This file can be used to restore a database to a SQL Server.
Restore Database: The process of using a .bak file to either create a new Application database on SQL Server or restore an existing database to a prior state.
Note: If you have an existing .bak backup file already, you can skip to the Restore Database section.
Back up Database
2. Expand Databases and locate the Application database (e.g., CPMAppHost or Sample App-Advanced).
Tip: The Application database has the same name as the Application in Kepion.
3. Right-click the database and select Tasks > Back Up…
7. Click OK on the Select Backup Destination dialog.
Once the backup is complete, the following dialog will appear:
Your database backup file will now be available at the specified file location.
Tip: You can choose to zip the <application_name>.bak file to minimize the size.
1. Open SQL Server Management Studio and connect to your SQL Server.
2. Right-click Databases and select Restore Database…
3. Set the Source to Device and select ...
4. Select File from the Backup media type drop-down.
5. Click Add to pick the .bak files you wish to restore.
6. Locate the file to restore and select OK.
Note: If you do not see your .bak file, you will need to manually copy the file to the directory specified in Backup File location.
7. Once all the files you wish to restore have been selected, click OK.
8. Verify all the information is correct. Once you’re ready to restore the selected databases, click OK.
You should see the following dialog if the restoration is successful: