MS SQL Database Migration

<< Click to Display Table of Contents >>

Navigation:  Software Overview > RMS Monitoring Software > Server Software Installation >

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:

oSetup Connection Configuration for wPage.

oSetup Connection Configuration for wService.

>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