Database Migration

Jonathan Semones -

Use the following instructions to move the database to a new SQL server and reconnect the other Lucity components.

  1. Make a Full backup of the database(s) you are moving. 
  2. Copy the backup to new SQL server and restore database(s).
  3. If you are only migrating the database and you are not upgrading Lucity...
    • Go on a machine that has Lucity Desktop installed and look for the Client Maintenance program.  A link can be found under the Start menu > Programs > Lucity > Admin Tools.
    • Run Client Maintenance and point to the new SQL Server instance.
    • Update DSNs.  This is done by running the Lucity DSN Utility on each desktop machine. (this tool is found in the desktop install's bin folder and will repoint Lucity Desktop to the Lucity Server and SQL databases.).  It can be run silently as part of a script, so they can push the change out through active directory.
    • Uninstall and reinstall any of the following that you have: Lucity Web, Web Citizen, REST API's, Mobile Server.  Make sure during these installs to point to the new SQL Server instance.
    • The process is complete.
  4. If you are only migrating the database and you are upgrading Lucity...
    • Begin performing the Server install.  Be sure to point to the new instance of SQL Server.
    • Complete all other Lucity installs as normal.  Make sure to point to the new SQL Server instance whenever prompted for SQL Server information.
  5. If you are migrating the database and you are also migrating the the Lucity Config folder continue to the next article for instructions.
Have more questions? Submit a request

Comments