Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

\uD83D\uDCD8 Instructions

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 EPPOC IT about altering the config file)

  7. Start epiCentre ,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

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#FF8F73

Epicentre config files store database information in an encrypted format. If database server name or ip address changes, please contact eppoc eppoc-uow@uow.edu.au

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@4d324212
sortmodified
showSpacefalse
reversetrue
typepage
labelskb-how-to-article
cqllabel = "kb-how-to-article" and type = "page" and space = "~6345f2207d10ef7914929747"