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 Installation of the RMS Software V2.3.1 chapter.