Introduction
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.
Definition
Before we begin, we'll define and differentiate between backing up and restoring application databases.
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 create a new application database on SQL Server or restore an existing database to a prior state.
Note: If you already have a .bak backup file, skip to the Restore Database section.
Back up database
2. Expand Databases and locate the application database (e.g., 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…
5. Select Add…
7. Select 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.
Restore database
1. Open SQL Server Management Studio (SSMS) 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. Select 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, select OK.
8. Verify all the information is correct. Once you’re ready to restore the selected databases, select OK.
You should see the following dialog if the restoration is successful: