How to move IAS database from local SQL Server Express to an external SQL Server

Applies to:

Application Suite

Description:

Steps to move IAS database to another SQL Server instance

Solution:

Make sure the destination SQL server is the same or higher version of the source SQL server.

1. Make sure your SQL is already installed on the destination machine and that you have username and password for it
2. Run the "Imagicle Backup and Restore" utility and click on the "Backup" tab
3. Set a destination path for the backup and click "Run Backup"
4. Once the backup is complete, click on the "Restore" tab
5. Click on "Stop All Applications" and confirm
6. Wait for a confirmation message, and then close the "Backup and Restore" utility
7. Open a command prompt and run: <IAS_INSTALLATION_DIR>\System\BackupRestore.exe /UPGRADE
8. Enter the data to access the destination SQL Server instance and click "Connection test"
   1. if the connection test fails check inserted data and try again
   2. only if the test passes, click "Next"
9. Follow the configuration wizard and wait for it to complete
10. Run again the "Imagicle Backup and Restore" utility and click on the "Restore" tab
11. Click on "Stop All Applications"
12. Choose the path to the backup you created in step 3 and click "Restore Now"
13. Confirm the data to access the destination SQL Server instance and click "Next"
14. Follow the instructions until the restore procedure is complete
15. Reboot the server