Knowlege base

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

Article ID: 355
Last updated: 16 Jan, 2017

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
Article ID: 355
Last updated: 16 Jan, 2017
Revision: 5
Views: 543
Print Export to PDF Subscribe Share
This article was:  
Prev   Next
IAS web page returns error IIS error 500.19 Dynamic Compression...     How to move a SQL database to a new server