Start a conversation

How to move your RMS database server (MSDE or SQL 2005/2008 R2 Express)

If you need to move your RMS database to another PC on your network, follow these instructions. You can use this method to temporarily move the RMS database while a server is being replaced, or to migrate your RMS database to a new server.

IMPORTANT: These instructions apply to a default RMS installation using MSDE (RMS 1.x) or SQL 2005 Express (RMS 2.0) or 2008 R2 Express. If you are deploying the full version of SQL Server on your new server, the procedure will differ based on the tools available in the full version of SQL. However, you can always use the following method to create a temporary server as long as the backup file is named with the .bck extension and the version of SQL between the old and new server are compatible. Example: SQL Server 2000 to MSDE, or SQL Server 2005 to SQL 2005 Express. Also keep in mind MSDE is limited to 2G and SQL 2005 Express is limited to 4G. If your database is larger than 4G, you'll need to upgrade the 2005 instance to SQL 2008 R2 (contact our help desk for assistance). 

Please note DRS does not support RMS or DRS add-ins on SQL versions higher than 2008 R2. Problems have been reported with SQL 2012 or higher.

Old server
Run Store Operations Administrator on your current server.
Select File, Connect, enter your connection settings, and click OK.
Select Database, Backup, and make a backup on the local drive.
Copy the backup file you just made to the new server (over the network to a shared folder on the new server or by using a CD-R, flash drive, etc.).

New server
Prep: Make sure MSDE or SQL 2005 Express is installed and running on the PC to be used as the new server. If not, reinstall RMS using the installation CD, but do not skip SQL Server when prompted.

Run Store Operations Administrator on your new server.
Select File, Connect, and make sure Server is set to (local).
Enter your connection settings and click OK.
Select Database, Restore, and create a new database using the backup file and the same name as the original database.
Select File, Configuration, and change the Server to (local).
Click Test Database then OK, OK.

All other workstations
On all other workstations run Store Operations Administrator.
Select File, Configuration, and change the Server name to match the computer name of the new server. If you are not sure what that name is, right-click on My Computer (on the new server) and select Properties, Computer Name, Full Computer Name. Enter that name as the Server on your workstations.
Click Test Database then OK, OK.
Run Store Operation Administrator on all other workstations, change the Server name under File, Configuration, and test the connection to ensure the workstations are connecting to the new server. After testing click OK, OK to activate the new settings.

WARNING: You must disable SQL on old server after a successful move or move the database files. Otherwse stations may connect to the wrong server in error if the old PC remains on the network.

Choose files or drag and drop files
Was this article helpful?
  1. Dave J

  2. Posted
  3. Updated