Migrating the epiCentre database from one SQL instance to another

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. Create instance logins in DB2 and link them to the appropriate roles in the newly restored database
   1. You can use the SQL Login Creation script to automate the creation process
      1. Please ensure instructions in the script are followed and properly replace the placeholders
   2. For best results, ensure that the same usernames and passwords are used as in DB1
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.
7. Start epiCentre
   1. If the credentials created in step 5 were the same as in DB1, epiCentre should connect to the server and show the login screen
   2. If the credentials created in step 5 are different (either username or password), epiCentre should be showing the database configuration wizard. Follow the instructions of the wizard, only changing the information that requires changing due to the move from DB1 to DB2
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