Sage CRM and Database Server Migration

What to Do in Sage CRM after a Database Move

 

Learn how database server migration affects Sage CRM and the necessary steps to do within Sage CRM after the database is migrated to a different server.

Typically, server hardware is upgraded every few years. Sometimes servers just go down and have to be replaced. When either of these situations happens, databases have to be migrated to the new server. After databases are migrated, application software has to be updated to point to the new hardware.  This article details the necessary steps that need to be taken within Sage CRM after the database is migrated to a different server.

  1. Open the Registry Editor and change the following parameters accordingly. The password can be typed in plain text mode.

 

Migrating Sage CRM to a New Server 1

 

  1. Go to the following application path and open the db.properties file and adjust the following parameters accordingly. The password can be typed in plain text mode.

db.url=jdbc:log4jdbc:jtds:sqlserver://[SQLservername]:[port]/databasename;language=english;

Migrating Sage CRM to a New Server 2

 

After saving the changes, reset IIS in the application server.

Now you should be able to login to CRM.

Encrypting the SQL Password:

The SQL password can be encrypted in registry by going into following area,

  1. Back up the db.properties file.
  2. Type the new SQL credentials in screen below and save. The screen is accessed via Administration -> System-> Database.
  3. Change the SQL password in the backed up properties file to encrypted password and save.
  4. Then copy the encrypted password from the registry area shown in the screenshot above.
  5. Now replace the original db.properties file with the updated file.
  6. Reset IIS.

Migrating Sage CRM to a New Server 3

 

If the Sage CRM Application Server has also changed, make sure to follow below steps in the SQL database.

  1. Open the SQL Management Studio and connect to CRM database.
  2. Run the following query.

Update Custom_Sysparams set parm_value = ‘[new servername];’  where parm_name = ‘Servernames’

  1. Reset IIS.

Migrating Sage CRM to a New Server 4