CenterPoint Accounting - Transferring CenterPoint Data to a New Server

Document #: 3048 Product: CenterPoint®

There are three steps that will need to be completed to effectively move CenterPoint databases from one server to another.

Step 1 - Create a Backup of the Databases on the Old Server

Step 2 - Install CenterPoint at the New Server & Restore Data

Step 3 - Database Maintenance at Each Workstation

Step 1 - Create a Backup of the Databases on the Old Server:

  1. Create a backup of your CenterPoint database through the CenterPoint program by following the Backup and/or Restore a Network Database document.
Note: If you do not have the document, it can easily be accessed. From within CenterPoint, select Help > CenterPoint Help. From within the Help, in the Search bar, enter Backup, click , and then select the Backup and/or Restore a Network Database document or click here.
  1. Once the backup is complete, move the file to some sort of removable storage device (CD, flash drive, external hard-drive, etc.) if you did not select to save to one of those locations originally.

Step 2 - Install CenterPoint at the New Server & Restore Data

  1. Follow Step A (only Step A) of your Network Installation Instructions document.
Note: If you do not have the document, it can easily be accessed. From within CenterPoint, select Help > CenterPoint Help. From within the Help, in the Search bar, enter Network Installation, click , and then select the Network (Multi-User) Installation Instructions document or click here.
  1. Once the program is installed on your server, open CenterPoint and go to File > Restore database. Connect/ to or insert your removable device that you saved your backup file to (CD, external hard drive, flash drive, etc.).
  2. Click Browse in the Backup file to restore field and browse to your removable storage device that you saved the backup file to in Step 1 of this document.
  3. Select your backup file (“yourdatabasename.cpz”) and click Open.
  4. In the Database to Restore box, make sure this is the name you want for your database (can be changed if you want).
  5. Verify that the Server box says (local)\RWS.
  6. Click Restore.

Step 3 - Database Maintenance at Each Workstation

  1. At a workstation, select File > Administration > Data Maintenance. If prompted, click OK to close the current database.
  2. In the Database Maintenance screen, select the database(s) and click Remove.
  3. At the Are you sure you want to remove the database from the database list? message, select Detach Database From Server and click Yes.
  4. Select Yes to continue detaching the database. 
  1. Then follow Step B-5 (skip Step B1-B4) of your Network Installation Instructions document to add the new server and databases.
Note: If you do not have the document, it can easily be accessed. From within CenterPoint, select Help > CenterPoint Help. From within the Help, in the Search bar, enter Network Installation, click , and then select the Network (Multi-User) Installation Instructions document or click here.
  1. Repeat steps 1-5 at each workstation.

Concept Link IconSee Also