Zumero for SQL Server v2.0.1 - Release Notes
Zumero for SQL Server (ZSS) v2.0.1 is now available for download in the dev center.
ZSS version 2 is a significant upgrade over previous ZSS releases. If you are upgrading from a ZSS v1.x release, please read the Upgrading from ZSS 1.x section below to ensure an easy and safe transition.
New Features in ZSS 2.0.1:
- Significant performance improvements during syncs, particularly for heavily-filtered tables.
- ZSS now includes limited support for syncing GEOMETRY, GEOGRAPHY and HIERARCHYID columns (to SQLite blobs). See the ZSS Manager documentation for details and caveats.
Fixed in ZSS 2.0.1
- Some warnings were not being included in ZSS Manager’s Overview page. An erroneous “triggers will not be synced” warning was removed.
- The Users and Permissions dialog was not allowing the use of user tables in the primary database.
- Ensure propagation of SQL errors in situations where the error text was previously lost.
- ZSS Manager can once again prepare tables when the database default collation does not match the server’s default collation.
Upgrading from ZSS 2.0.0:
- Upgrade your ZSS Server. The IIS Zumero web site should be stopped before running the ZSS Server installer to upgrade from v2.0.0.
- Upgrade ZSS Manager
- Connect to your SQL Server database with ZSS Manager, and follow the upgrade prompts (see Upgrading in the ZSS Manager documentation). If you have multiple databases, you may want to examine them all for upgrades.
Upgrading from ZSS 1.x:
For a walk through of the steps needed to upgrade from ZSS 1.x to 2.0, view our Upgrade Tutorial.
Activation
ZSS Server licenses now require activation. Please visit the Activation page to activate any existing license keys for use with ZSS 2.0.
Upgrade Order
The recommended order for upgrading to ZSS 2.0 is:
- Upgrade ZSS Manager
- Connect to your SQL Server database with ZSS Manager, and follow the upgrade prompts (see Upgrading in the ZSS Manager documentation). If you have multiple databases, you may want to examine them all for upgrades.
- Upgrade your ZSS Server. The IIS Zumero web site should be stopped before running the ZSS Server installer to upgrade from v1.x.
- Replace the client libraries that you’re using. Rebuild your app and redeploy.
Compatibility
Zumero 1.x clients will work with ZSS 2.x servers, but will not be able to take full advantage of the improved support for concurrent syncs on SQL Azure. Also, older clients will not support arbitrary row filters even when syncing with a 2.x server, but are still subject to the previous restrictions. Thus it is strongly recommended that all Zumero clients synchronizing against a SQL Azure database, or using a row-inclusion WHERE clause, upgrade to 2.x as soon as possible. Newer clients will not sync with ZSS 1.x servers.
The first time a newly-upgraded client application syncs, the sync may be more time- and bandwidth-intensive than usual as filtered data is fully refreshed.