Migrating the KDS-HRIM database to another server

Keystyle Support Team -

If you need to move the KDS-HRIM database to another server, please be sure to address the following items during the migration.  Please note that if you are separating the KDS-HRIM and Viewpoint database as part of this migration, contact KDS support for linked server setup assistance.

For the database migration:

  1. Be sure the new server SQL collation is set to Latin1_General_BIN
  2. Migrate the KDSUser login and user to the new server.
  3. Migrate all SQL Agent jobs beginning with "KDS-HRIM" to the new server - there should be approximately 7 jobs.

On the Keystyle IIS server, navigate to:

C:\Program Files (x86)\Keystyle Data Solutions\Keystyle Data Solutions\HRIM\Config

In the "Connections.config" file, in the "connectionStrings" property, replace the old server with the new server name in the highlighted locations below:

IIS restart should not be required.

If you experience any issues or need additional support, please don't hesitate to contact KDS support.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk