Zumero


Zumero for SQL Server v1.0.1 - Release Notes

Zumero for SQL Server v1.0.1 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 v1.0.0

  • Encryption keys are now handled properly when syncing SQLCipher-encrypted dbfiles
  • A superfluous dependency in the iOS Client SDK was removed.
  • More details are now available on server errors in the Event Log.
  • License keys now expire at UTC day’s end.
  • Clients now get an informative error message for invalid or expired license keys, not just a generic HTTP 500.
  • There were several documentation updates.

Upgrading from v1.0.0

  • The IIS Zumero web site must be stopped before running the ZSS Server installer to upgrade.

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.1:

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.1 install to upgrade it.
  • In the 1.0.1 version of ZSS Manager, recreate dbfiles and re-prepare tables.
  • Re-set user permissions.
  • Run the ZSS Server 1.0.1 install to upgrade it. The web site should start, and the static page should have the new version number: 1.0.1.1596 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.1 server.

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

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.1:

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.1 install to upgrade it.
  • In the 1.0.1 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.1 install to upgrade it. The web site should start, and the static page should have the new version number: 1.0.1 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.1 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.1, we’d love to help. Contact us at support@zumero.com.