DS-System database migration tool (Cross-Platform)
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.
- The MSSQL ODBC driver is already installed if the computer has MS SQL installed.
- The PostgreSQL driver installation is provided together with the DS-System database migration tool (filename: psqlodbc_x64.msi). Double-click to install it.
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:
- If the source database is at a specific release level (e.g. v12.0.0.0), you can run a fresh installation of that release version and they will be equal.
- Otherwise, you can run the full DS-System database script (filename: mssqldssystem.sql or postgresdssystem.sql) from that release on the target destination database.
- If the source database is at a higher level (of database patches) than the destination, you must run all missing patches on the destination to bring it up to the same level as the source before running the tool.
6. Start the tool and select the source and the destination databases.
- for named instances, enter the full "server name or IP\instance name"
- for un-named instances, enter only "server name or IP address"
7. Click OK. The Data migration screen appears.
- If you successfully connected to both database servers, you will see them in the drop down lists in the Parameters section.
- If there were any errors, they will appear in the Progress section.
8. Verify the Source Database and Destination Database are correct. Click Start.
- The progress of the migration appears.
- The Tool will issue errors for any problems it encounters. These must be fixed.
- However, ignore the following error:
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.
- The Extensible Storage Paths screen appears with the current settings from the "Destination Database".
- Highlight each path, and update it. Click OK when you are finished.
10. Delete the Source Database (in order to make sure no DS-System will try to use it).
11. To complete the migration:
- If the DS-System is already installed, start the service / daemon on the target machine.
- If you only migrated the database, install DS-System on the target machine and configure it to use the migrated Database.
How the program works
- The program uses ODBC connectivity to connect to either Microsoft SQL Server or PostgreSQL.
- Upon connecting using the provided hostname/IP & credentials, the Tool will try to get a list of existing databases (it may fail, in which case an error will be reported). In any case, the Tool will set the Source Database and Destination Database names to "dssystem".
- The Tool copies 5000 rows at a time.
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.
![]() ![]() |