Moving CMS to a New Server

From NewHaven Software Wiki

---

Revision as of 02:53, 26 November 2009

CRITICAL!!! ALL USERS MUST EXIT CMS PRIOR TO INSTALLING CMS SERVER ON ANOTHER COMPUTER!!!

CRITICAL!!! YOU MUST BE LOGGED IN AS THE COMPUTER ADMINISTRATOR OR A USER THAT IS A MEMBER OF THE ADMINISTRATORS GROUP!!!

1. MAKE BACKUP IMAGE OF CMS DATABASE FILES

  a. Select the Admin menu. 
  b. Select Database Maintenance. Note the settings on the Daily Backup tab so you can restore them, if necessary. 
  c. Select "Perform the daily backup..." 
  d. Select and delete any text in the "Folder in which to create a backup..." field. 
  e. Click the Browse button, select Desktop in the window that opens, and click OK. 
  f. Click the "Immediately create a Backup Image..." button. This will create a copy of your database and log files onto the Windows desktop. 
  g. Click the Close button. 
  h. Exit CMS if it is still open.

2. STOP AND DISABLE THE ADAPTIVE SERVER ANYWHERE SERVICE

  a. Click the Windows Start button, then select Settings --> Control Panel --> Administrative Tools --> Services.
  b. Click once to select Adaptive Server Anywhere (usually the top entry in the right column).
  c. Click the STOP link or right-click and select STOP.
  d. Once the service Status no longer displays STARTED, right-click again and select Properties. Click OK to the warning that pops up.
  e. Change the Startup Type to MANUAL, and click OK.
  f. Close all windows.

3. RETRIEVE ODBC CONFIGURATION SETTINGS

  a. Click the Windows Start button, then select Settings --> Control Panel --> Administrative Tools --> Data Sources (ODBC). This will open the ODBC Data Source Administrator control panel.
  b. Select the System DSN tab.
  c. Double-click the name that is your CMS database name (usually your company name).
  d. Select the Database tab.
  e. Write down the SERVER NAME (should be NHSDataServer) and the DATABASE NAME. This information will be used in your new CMS Server installation.
  f. Click the CANCEL button until all windows are closed.

4. Disable sharing on the NewHaven Software folder.

5. On all CMS Workstation computers, disconnect the mapped drive to the NewHaven Software folder on the old CMS Server computer.

6. Install CMS Server on the new computer. Refer to the CMS Installation Manual. What is important is to enter the SERVER and DATABASE names that you wrote down from the old computer. Reboot the computer and verify that you can login to the new CMS Server installation. Exit CMS.

7. Repeat Steps 2a-c to stop the ASA service. DO NOT CHANGE THE STARTUP TYPE.

8. Create a new folder in the NewHaven Software\Data folder. Name it CLEAN.

9. There should be two files in the NewHaven Software\Data\yourdatabasename folder; one with a .db extension and one with a .log extension. Move both of these files into the NewHaven Software\Data\Clean folder you just created.

10. Copy the .db and .log files from the old CMS Server computer into the NewHaven Software\Data\yourdatabasename folder on your new CMS Server computer.

11. Restart the ASA service.

12. Log into CMS and confirm it is working. If you get a database mismatch error message, you will need to rerun the setup and reboot the computer in order to sync up the CMS application and database.

13. Check your CMS backup settings in Admin/Database Maintenance to ensure the path that it is using to backup its files is still valid on this server.

14. Once you confirm CMS is working on the new installation, you can share out the NewHaven Software folder so that the CMS Workstation computers can remap the drive to the new installation.

15. Uninstall CMS Server from the old computer to ensure the potentially conflicting ASA service is removed and that everyone is running CMS from the same directory on the new CMS Server computer.

<end>