Skip to content

MS SQL Database Migration

When migrating from one MS SQL database to a new one, here are the steps that need to be taken into account.

Step 1 Carry out a backup of the exisiting MS SQL database.
Step 2 Import the backup to the new MS SQL database.
Step 3 Setup the MS SQL rmsUser: please see as of step 5 in the Creation of a New Database chapter.
Step 4 Adapt the connections.config files:
- V1.3.1 or lower:
- >V2: please see as of step 6 in the following chapter:
-Installation of the RMS Software V2.6.1 Using Mixed Authentication Mode
-Installation of the RMS Software V2.6.1 Using Windows Authentication Mode
-Installation of the RMS Software V2.6.1 not on C: with Mixed Authentication Mode
-Installation of the RMS Software V2.6.1 not on C: with Windows Authentication Mode