Migrating CData Sync from the .NET Edition to the Cross-Platform Edition

  • 10 May 2024
  • 0 replies

Userlevel 1

Starting with Sync 2024, the .NET edition of the application is deprecated. As a result, users need to migrate their current .NET edition of Sync to the Cross-Platform edition. Follow these steps to perform this migration:

  1. If you are using the default SQLite application database, you must export your settings and then re-import them when you start the Cross-Platform edition of Sync. The Cross-Platform edition does not support SQLite as an application database. It uses the Apache Derby database, by default. You can export your settings from the Migrations tab on the Settings page in Sync. Simply click Export to download all your jobs, connections, and Sync settings into zipped CSV files.

    Important: If you are using PostgreSQL, MySQL, or SQL Server as your application database, you do not need to export your settings. The Cross-Platform edition supports these three application databases, and it will update the system tables when you start the Cross-Platform edition for the first time. As a best practice, you should create a backup of the Sync system tables by copying them into a different database or schema.
  2. (Optional) Rename the .NET application folder so that the new Cross-Platform edition will be installed in a separate folder.
  3. Download and install the Cross-Platform edition from the CData website. During installation, the new download should overwrite the CData Sync service definition.

    Note: Before you start the server, you need to update the sync.properties file if you are using an external database. You can change the port, change the inactivity (session) timeout, and more in this file. For example, you can change the port by locating the following line in sync.properties and changing the default port (8181) to a port of your choice:

  4. Start the Sync application and install your license from the License tab on the Settings page.
  5. Import the settings that you exported in step 1.

After you complete your installation, you can configure security features (such as enabling SSL/TLS and LDAP authentication) or deploy Sync to a web server such as Microsoft Internet Information Services (IIS).

0 replies

Be the first to reply!