Migrating From SqlCe To SQLite
With the release of Zynk 2022.1.1 we introduced support for SQLite databases.
This provides a number of benefits, such as increased reliability and less restriction on file sizes.
Below is a guide on migrating from SqlCe to SQLite:
1. Stopping the Schedules
If Zynk runs automatically, it's important to make sure this is paused while the migration takes place.
Information on doing this can be found here: Stopping a Workflow
2. Updating Zynk
The next step in migration is to update Zynk to a compatible version.
If you aren't already on 2022.1.1 or above, we recommend installing the latest version of Zynk, available from http://downloads.zynk.com/files/setup.exe
To begin the migration process, log into Zynk and access the Database menu by going to Tools -> Options -> Database
From here, you should be able to see that both your current Zynk and Log Databases are in SqlCe.
Select the drop down menu for Zynk Database and choose SQLite from the drop down menu.
Select the "Create Database" option.
Once the database has been successfully created, choose the "Migrate Data" option.
In the Database Migration window that appears, ensure that Source is set to Zynk.sdf and Destination is set to Zynk.db
From the final drop down menu you can choose to migrate All Data or Records Since and specify a timestamp.
Once all the settings are in place, choose Start to begin the migration.
- Although the migration steps above describe migrating the Zynk.sdf database, the steps for migrating Log.sdf are exactly the same.
- The time taken for the migration is completely dependent on the amount of data present in the databases and how much you are keeping.
- We recommend migrating All Data wherever possible to avoid issues with duplication