DS-System database migration tool (Cross-Platform)


Creation Date: September 18, 2006
Revision Date: December 20, 2012
Product: DS-System database (MS SQL & PostgreSQL)

Summary

The DS-System Database Migration Tool (filename: dssdbmigrate_x64.exe) allows you to migrate an existing DS-System database across SQL platforms:

The DS-System Database Migration Tool can only be run on a Windows computer, but it can read from and write to PostgreSQL databases installed on networked Linux machines.

Migrate the DS-System database (cross-platform)

To migrate data from an existing database to a different database:

1. Install the PostgreSQL ODBC driver & MSSQL ODBC Driver on the machine where the tool will run.

2. Make sure you know the version of the source database (dssystem).

TIP: It is simplest if you are migrating an installation that is at a specific release level. This way, you can run the same release installation on the target database and know they will be equal.

3. Stop the DS-System service on the source computer (the source database must not be in use).

4. Backup the source database (dssystem).

5. Make sure the target destination database (dssystem) is at the same version level as the source:

6. Start the tool and select the source and the destination databases.
For MS SQL
In the 'Server' field:
  • for named instances, enter the full "server name or IP\instance name"
  • for un-named instances, enter only "server name or IP address"
In the 'User Name' field:
  • enter the Database username
  • If there is no username, leave this field blank. In some cases, you may need to enter "(local)" into this field (without quotes).
In the 'Password' field:
  • If there is no password for the database user, leave the 'password' field empty.
For PostgreSQL
  • In the 'Server' field, put the IP address of the database machine
  • In the 'User Name' field, put the Database username.
  • If there is no password, leave the 'password' field empty.

7. Click OK. The Data migration screen appears.

8. Verify the Source Database and Destination Database are correct. Click Start.

9. After the data has been migrated, click "Change Extensible Storage Path(s)" to update the storage location paths on the Destination Database. Normally, when the Operating System is different, the paths will also differ.

10. Delete the Source Database (in order to make sure no DS-System will try to use it).

11. To complete the migration:

How the program works



The information provided in this document is provided "AS IS", without warranty of any kind. ASIGRA Inc. (ASIGRA) disclaims all warranties, either express or implied. In no event shall ASIGRA or its business partners be liable for any damages whatsoever, including direct, indirect, incidental, consequential, loss of business profits or special damages, even if ASIGRA or its business partners have been advised of the possibility of such damages. © Asigra Inc. All Rights Reserved. Confidential.


PREVNEXT