How to migrate your database to a new server

Expand / Collapse
 

How to migrate your database to a new server


Article ID: 51964 - Last Review: July 27, 2015

INFORMATION

When upgrading from a 6.0.X.X environment to 7.0.X.X you may wish to move to a new server as well.  When doing this there are two ways of carrying your configuration over:

  • The preferred method is to install the new SQL server and use the configuration wizard to generate a blank database.  Then, using a configuration backup and resummarizing data you can rebuild the environment.  This allows for a clean database with only the reporting data required.
  • Migrating your existing SQL database.  If you have reporting data for a long period already committed to the database, have had staffing changes since that data was summarized, and need to continue to report on that old data, then migrating the SQL database as a may be required.


PROCESS TO MIGRATE AN EXISTING DATABASE

1. Ensure that you retain a configuration backup and the \DataDirectory\ folder from the old server, as a redundant backup.
2. Backup the SQL database (CCMData and CCMStatisticalData).
3. Set up the new server hardware and pre-requisite components.
4. Restore the backed up databases to the new server.
5. Run the Installation as normal.  The installation process will detect the existing database and update the SQL Schema automatically.



APPLIES TO

7.0 and newer

Keywords: migrate database db ccmdata ccmstatisticaldata upgrade



Rate this Article:
     

Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:Tuesday, July 28, 2015
Last Modified By: AndrewM
Type: HOWTO
Article not rated yet.
Article has been viewed 10,932 times.
Options