There have been significant changes since the first preview. All three components have changed: client, server, and manager. More specifically:
-
Zumero's client library is no longer a sqlite extension. You no longer sync via a sqlite function. Instead, you simply call the sync routine in the Zumero client library. You may work with the sqlite data on the client using the platform-native sqlite API.
-
Housekeeping data on the client is now maintained with triggers, like the server.
-
There is now formal support for schema changes to prepared tables. ZSS Manager includes features to facilitate them.
-
On the server, Modify and Delete permissions are now separate.
There have also been a myriad of bug fixes. A few notables:
-
Money, smallmoney, decimal, and numeric columns are better behaved. They are stored as integers on the client, padded to include their decimal portion.
-
Date and time fields have better validation on the client.
-
Uniqueidentifier and varbinary(max) fields are now truly supported by the server
If you used the first preview of Zumero for SQL Server (ZSS), the following steps are necessary to upgrade to preview 2:
-
In IIS Manager, stop the Zumero web site.
-
Using the Preview 1 version of ZSS Manager (0.9.0.1082 or older), unprepare all tables and delete all dbfiles. This is important. The new version ZSS will be confused by old data. The preview 1 version of ZSS Manager is still available for download here.
-
Run the Preview 2 ZSS Manager install to upgrade it.
-
In the Preview 2 version of ZSS Manager, recreate dbfiles and re-prepare tables.
-
Fix user permissions, noting that modify and delete are now distinct.
-
Run the Preview 2 ZSS Server install to upgrade it. The web site should start, and the static page should have the new version number: 0.9.5.1382 or later. (You may have to manually refresh the page to see the new version.)
The details are platform specific. Consult the README in the client SDK. In general:
-
Remove any existing client databases. They'll need to be recreated by syncing with a Preview 2 server.
-
Replace the sqlite extension library with the new Zumero client library.
-
Replace "select zumero_sync" in sqlite with calls to the client library's sync routine.
-
Change data manipulation code to use the platform native sqlite library.
If you would like specific advice about how to migrate an existing app from preview 1 to preview 2, we'd love to help. Contact us at support@zumero.com.