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 |