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:
- Be sure the new server SQL collation is set to Latin1_General_BIN
- Migrate the KDSUser login and user to the new server.
- 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.