...
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.
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 EPPOC IT about altering the config file)
Start epiCentre, EpiCentre it 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
...