Skip to end of banner
Go to start of banner

Migrating the epiCentre database from one SQL instance to another

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

For the sake of clarity, DB1 = original database instance and DB2 = new database instance


  1. Ensure that all users are not currently using epiCentre

  2. Take a backup of the database from DB1

  3. Take the database in DB1 offline to stop anyone from reconnecting to it

  4. Restore the backup in DB2

  5. After restoring the database , follow steps from this documentation to fix orphaned user after migration in SQL Server

  6. Update epiCentre's config file (default location of C:\epiCentre\epiCentre.config) on one machine to point to the new database server by changing the entries for dbserver and dbdatabasename. (Please contact AHSRI IT about altering the config file)

  7. Start epiCentre

    1. EpiCentre should connect to the server and show the login screen

  8. If the procedure has completed successfully, copy the updated config file and use it to overwrite the config file on all other epiCentre installations that are looking for DB1

  • No labels