For the sake of clarity, DB1 = original database instance and DB2 = new database instance
Ensure that all users are not currently using epiCentre
Take a backup of the database from DB1
Take the database in DB1 offline to stop anyone from reconnecting to it
Restore the backup in DB2
...
- You can use the SQL Login Creation script to automate the creation process
- Please ensure instructions in the script are followed and properly replace the placeholders
- For best results, ensure that the same usernames and passwords are used as in DB1
After restoring the database , follow steps from this documentation to fix orphaned user after migration in SQL Server
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)
Start epiCentre
...
EpiCentre should connect to the server and show the login screen
...
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