Zumero


Zumero for SQL Server v2.1 - Release Notes

Zumero for SQL Server (ZSS) v2.1 is now available for download in the dev center.

New Features in ZSS 2.1:

Active Directory Integration

ZSS Server can now authenticate syncing users against Active Directory.

Through ZSS Manager, you can set filters and permissions for individual Active Directory users and groups.

Support for User Groups

ZSS 2.1 adds support for Groups of users.

Now, in addition to setting permissions and filters for specific users, you can set permissions, filter rows, exclude columns, etc. based on a user’s membership in one or more groups.

ZSS Migration Wizard

ZSS 2.1 also fulfills the second-most-popular feature request - the ability to “migrate” a DBFile’s configuration from one ZSS Server to another.

If you’re moving from (e.g.) development to production, you no longer need to:

  1. Create the DBFile
  2. Prepare all the tables that were prepared in development
  3. Recreate filters
  4. Re-apply permissions

Point ZSS Manager to the new server’s database, and the wizard does the grunt work for you.

Sync Progress and Cancellation in the Client API

The most popular feature request is for progress reporting in the client. All ZSS Client SDKs now offer progress-report callbacks.

Your apps will be informed of:

  • The phase of the current sync (preparing, uploading, download, etc.)
  • Total bytes to be sent/received in the current phase
  • Bytes-so-far in the current phase

And given the option to cancel the sync-in-progress.

Simplified DBFile Creation

Creating a new DBFile (particularly in multi-database configurations) is now much simpler and more foolproof.

Enhanced Unicode Support

ZSS now supports arbitrary Unicode characters in table names, column names, and filter definitions.

Server Performance, Stability and Reporting Improvements

ZSS Server now reports (and logs) much more detail when a server misconfiguration error occurs.

rowversion columns, WHERE filters involving unsynced columns, and more are handled gracefully by ZSS Server.

Upgrade Instructions

Upgrading from ZSS 2.0.x:

  1. Upgrade your ZSS Server. The IIS Zumero web site should be stopped before running the ZSS Server installer to upgrade from v2.0.0 or v2.0.1.
  2. Upgrade ZSS Manager
  3. 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.1, 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.1.

Upgrade Order

The recommended order for upgrading to ZSS 2.1 is:

  1. Upgrade ZSS Manager
  2. 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.
  3. Upgrade your ZSS Server. The IIS Zumero web site should be stopped before running the ZSS Server installer to upgrade from v1.x.
  4. Replace the client libraries that you’re using. Rebuild your app and redeploy.

Compatibility

Older clients will work with ZSS 2.1 servers, but will not be able to take full advantage of the new features and improvements. Newer clients will not sync with old ZSS 1.x servers.

Release Notes Archive