Zumero


Zumero for SQL Server v1.0 - Release Notes

Zumero for SQL Server v1.0 is now available for download in the dev center. If you’ve been using a preview release, please follow the “Upgrading from Preview 2” or “Upgrading from Preview 1” instructions below.

Changes Since Preview 2

  • Fixed support for tables in SQL Server schemas other than dbo.
  • Implemented support for foreign key actions.
  • Fixed sync of VARCHAR fields larger than 1000 characters.
  • Improved menus and toolbars in ZSS Manager.
  • Fixed-width fields are now padded to full width on the mobile insert/update.
  • Fixed authenticated sync in Android.
  • Android now supports all of the client actions.
  • Added Cordova/PhoneGap libraries, currently supporting iOS and Android.
  • Fixed bugs in WinRT and Windows Phone 8 SDKs.
  • Added samples for WinRT and Windows Phone 8.
  • Broke compatibility with housekeeping tables from Preview 2 and before. Re-prepare needed.
  • Added support for NEWID(), GETUTCDATE(), and SYSUTCDATETIME() functions in DEFAULT.
  • Added support for Unicode text and blob literals in DEFAULT.
  • Changed client-side validation code from CHECK constraints to triggers, for greater flexibility and better error messages.

Upgrading From Preview 2

  • If you used the second preview of Zumero for SQL Server (ZSS), the following steps are necessary to upgrade to ZSS 1.0:

Server

  • In IIS Manager, stop the Zumero web site.
  • Using the Preview 2 version of ZSS Manager (0.9.5.1382), unprepare all tables and delete all dbfiles. This is important. The new version of ZSS will be confused by old data.
  • Run the ZSS Manager 1.0 install to upgrade it.
  • In the 1.0 version of ZSS Manager, recreate dbfiles and re-prepare tables.
  • Re-set user permissions.
  • Run the ZSS Server 1.0 install to upgrade it. The web site should start, and the static page should have the new version number: 1.0.0.1556 or later. (You may have to manually refresh the page to see the new version.)

Client

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 1.0 server.

If you would like specific advice about how to migrate an existing app from preview 2 to ZSS 1.0, we’d love to help. Contact us at support@zumero.com.

Changes Between Preview 1 and Preview 2

There were 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 were 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

Upgrading From Preview 1

  • If you used the first preview of Zumero for SQL Server (ZSS), the following steps are necessary to upgrade to ZSS 1.0:

Server

  • 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.
  • Run the ZSS Manager 1.0 install to upgrade it.
  • In the 1.0 version of ZSS Manager, recreate dbfiles and re-prepare tables.
  • Fix user permissions, noting that modify and delete are now distinct.
  • Run the ZSS Server 1.0 install to upgrade it. The web site should start, and the static page should have the new version number: 1.0.??? or later. (You may have to manually refresh the page to see the new version.)

Client

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 1.0 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 ZSS 1.0, we’d love to help. Contact us at support@zumero.com.

Release Notes Archive