Moving CMS to a New Server

From NewHaven Software Wiki

Jump to: navigation, search

Contents

Overview

This article details the instructions for moving your CMS installation from an old server to a new server including moving your data.

This process is a large undertaking that will require CMS to be down during the move. As a result please inform NewHaven Support of the day you plan to do the server migration. This is so we may either set up a appointment with you to guide you through the process, or at least ensure we have staff available to you in case you find you require assistance.

The following instructions our laid out in a broad 4 part process listed below

  1. Preparing to move CMS to the new System.
  2. Installing CMS on the new System.
  3. Moving the old Database to the new System.
  4. Updating the old Database to the new version of CMS

The above list is to help outline what exactly the following instructions are attempting to accomplish and to give you an overview of the process you are about to undertake.

Moving CMS on to a new server

Prerequisites

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!

Step 1 - Make a backup image of CMS Database files

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

Step 2 - Stop and Disable the Adaptive Server Anywhere service

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

Step 3 - Retrieve ODBC connection Settings

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.

  1. Select the System DSN tab.
  2. Double-click the name that is your CMS database name (usually your company name).
  3. Select the Database tab.
  4. Write down the SERVER NAME (should be NHSDataServer) and the DATABASE NAME. This information will be used in your new CMS Server installation.
  5. Click the CANCEL button until all windows are closed.

Step 4 - Disable sharing on the NewHaven Software folder

For information on how to do this please visit http://wiki.newhavensoftware.com/index.php/Folder_sharing_in_Windows

Step 5 - Disable all current mapped drive on CMS Workstations

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

Step 6 - Install CMS Server on the new computer.

  1. Start the CMS installer.
  2. In the CMS License Manager window, type the [customer number] and [release code] provided to you by NewHaven Software in the appropriate fields, then click OK.
  3. To accept the CMS License Agreement read through the agreement, then click OK.
  4. The Install Notes window is displayed. This window contains important information regarding the version of CMS you are installing. Read the install notes and click OK.
  5. The Welcome window asking you to exit all programs is displayed. If necessary, close any open programs and click the Next button.
  6. The Installation Type window is displayed. Select the Update CMS Installation (Server Only) option and then click the Next button.
  7. When the Full or update Install To SERVER ONLY!! window is displayed, click the Next button.
  8. The Choose Destination Location window is displayed. The recommended Destination Folder is displayed by default. Accepting the default destination folder simplifies the update installation process. This is the location for CMS on your Server. On the Choose Destination Location window, click the Next button.
  9. On the Database name window ENTER IN THE NAME OF THE DATABASE FROM YOUR OLD SERVER, MAKE SURE IT IS SPELLED EXACTLY THE SAME. Select Next.
  10. The Database Tools window is displayed asking if you want to install NHS Explorer. Select or deselect the NHS Explorer checkbox and click the Next button. NOTE: The NHS Explorer tool gives the administrator the option to view and edit database information. It is recommended that the NHS Explorer checkbox be selected for server installations.
  11. The Begin Copying Files window is displayed. To review the information contained in the previous windows, click the Back button. If all the settings are correct, click the Begin button.
  12. You will be presented with a Update Database window. In this window your database(s) will be displayed and checkmarked. Select ok to begin there update. Note: This process can take some time with very little to no indication that anything is going on, do NOT interrupt this process and do let it continue to finish unless a error message pops up.
  13. When the Installation Complete window appears, click the Finish button. 17
  14. When prompted, click OK to restart the computer.

Step 7 - Stopping the ASA service again

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

Step 8 - Copying over your Database file to the new system

  1. Create a new folder in the NewHaven Software\Data folder. Name it CLEAN.
  2. There should be two files in the NewHaven Software\Data\ ( Your Database Name) 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.
  3. Copy the .db file from the old CMS Server computer into the NewHaven Software\Data\ (Your Database Name) folder on your new CMS Server computer.

Step 9 - Recreate the CMS log file with dbsrv8.exe

  1. locate the dbsrv8.exe file in the NewHaven Software > asa8 > win32 directory. Example: C:\NewHaven Software\asa8\win32
  2. Run dbsrv8.exe
  3. Select the Browse button and locate the db file you are creating the log for.
  4. Highlight the DB file and select Open
  5. Where it says "Server Name" type in the database server name default is NHSDataServer
  6. Where it says "Options" type -f (tells the database to recover from a (f)ailure and recreate its log file)
  7. Select Ok. At this point a screen of commands will appear and then quickly disappear.

Step 10 - Forcing dbsrv8.exe to start the log file

  1. Run dbserv9.exe
  2. It should retain the settings you last entered, remove the -f from "Options"
  3. Select Ok
  4. After it finishes running through starting the dbeng verify that the log file is now in the database folder.
  5. Next stop the dbeng service by right clicking on the red and yellow SQL sign next to the clock on your taskbar. After right clicking select close.

Step 11 - Restart the ASA service. 

At this point if you are using the same version of CMS as was on your old system you should be able to start CMS. If however you are moving to a new version of CMS please continue to follow the instructions below

Step 12 - Run the CMS install file again to update the database

  1. Start the CMS installer.
  2. In the CMS License Manager window, type the [customer number] and [release code] provided to you by NewHaven Software in the appropriate fields, then click OK.
  3. To accept the CMS License Agreement read through the agreement, then click OK.
  4. The Install Notes window is displayed. This window contains important information regarding the version of CMS you are installing. Read the install notes and click OK.
  5. The Welcome window asking you to exit all programs is displayed. If necessary, close any open programs and click the Next button.
  6. The Installation Type window is displayed. Select the Update CMS Installation (Server Only) option and then click the Next button.
  7. When the Full or update Install To SERVER ONLY!! window is displayed, click the Next button.
  8. The Choose Destination Location window is displayed. The recommended Destination Folder is displayed by default. Accepting the default destination folder simplifies the update installation process. This is the location for CMS on your Server. On the Choose Destination Location window, click the Next button.
  9. The Database Tools window is displayed asking if you want to install NHS Explorer. Select or deselect the NHS Explorer checkbox and click the Next button. NOTE: The NHS Explorer tool gives the administrator the option to view and edit database information. It is recommended that the NHS Explorer checkbox be selected for server installations.
  10. The Begin Copying Files window is displayed. To review the information contained in the previous windows, click the Back button. If all the settings are correct, click the Begin button.
  11. You will be presented with a Update Database window. In this window your database(s) will be displayed and checkmarked. Select ok to begin there update. Note: This process can take some time with very little to no indication that anything is going on, do NOT interrupt this process and do let it continue to finish unless a error message pops up.
  12. When the Installation Complete window appears, click the Finish button. 17
  13. When prompted, click OK to restart the computer.

Step 13 - Log into CMS

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. To do so please follow the instructions in 14a-m

Step 14 - Check your backup

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.

== Step 15 - Sharing the NewHaven Software folder == 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. For information on how to do this please visit http://wiki.newhavensoftware.com/index.php/Folder_sharing_in_Windows

Step 16 - Removing CMS from the old system

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.

Retrieved from "http://wiki.newhavensoftware.com/index.php/Moving_CMS_to_a_New_Server"
Personal tools