Database Migration

<< Click to Display Table of Contents >>

RayVentory Server > 12.6 > Installation Guide > Migration 

Database Migration

1.Backup the database

2.Open an administrative command window

3.Navigate to the Database Migration folder

4.Run mgsDatabaseUpdate.exe with the relevant command line parameters that suit your environment

5.Re-index the database by running the ReIndexAll.sql query against it

 

Parameter

Value

Comment

-d

Database name

If not supplied, ManageSoft will be used.

-f


Forces the database into single user mode.

-i

DeploymentManagerMigration.xml

Configuration file describing the migration tasks.

-l

Log file name

If not specified, DeploymentManagerMigration.log will be used.

-s

Server name

SQL Server name + instance name if required.

-u

User name

Only required if SQL authentication is being used.

-p

Password

Required by the –u command.