SQL Maestro Group / News / All company news / Data Sync advanced to version 15.3

Data Syncs advanced to version 15.3

Mar 16, 2015

SQL Maestro Group is happy to announce the release of Data Sync 15.3, a powerful tool for comparing database contents and synchronizing differences. There are versions for MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite, Firebird, DB2, SQL Anywhere and MaxDB.

Please consider the list of new features implemented in this version since the last major release:

New features:

An ability to select or disable certain synchronization operations (Insert, Update, and Delete) has been implemented. The corresponding command line switches have been added as well.
Picture 1. Data comparison options
Now it is possible to specify SQL scripts to be executed before and/or after synchronizing data of each table. A typical example of using this feature is when the project contains several SQL Server tables with autoincrement columns. In this case you need to execute SET IDENTITY_INSERT %target_table% ON and SET IDENTITY_INSERT %target_table% OFF before and after processing the next table accordingly.
Synchronization script file name and log file name are now stored in the project file. These settings can be overwritten with the appropriate command line options.
Picture 2. Synchronization options
The first page of the wizard has been redesigned in order to provide more comfortable access to recently opened projects and display the latest company news.
The progress windows are redesigned in the modern style and become more informative.
Picture 3. Progress Window

Connectivity enhancements:

Support for keyboard interactive SSH authentication has been added (when applicable). This method provides for a multiple challenge-response dialog with the user in which the server sends a text query to the user, the user types in a response, and this process can repeat any number of times to ensure that the client is a human.
Picture 4. SSH Options: keyboard interactive authentication

Starting from this version, you can connect to connect to a Microsoft SQL Server database using any of SQL Server Native Clients installed on your computer (whereas all the previous versions operated only via Microsoft OLE DB Provider for SQL Server). To choose a client you want to use, select the appropriate item in the Provider combobox on setting connection properties.

Picture 5. Create Database Wizard: selecting a provider

The table below shows the correspondence between the value selected in the Provider combobox and SQL Server client to be used.

Value	SQL Server client	Introduced with
SQLOLEDB	Microsoft OLE DB Provider for SQL Server (default value)	Comes with Windows
SQLNCLI	SQL Server Native Client	SQL Server 2005
SQLNCLI10	SQL Server 2008 [R2] Native Client	SQL Server 2008 [R2]
SQLNCLI11	SQL Server 2012 Native Client (recommended)	SQL Server 2012

We would recommend you to install and use SQL Server 2012 Native Client as it provides the best support for data types implemented in the recent versions of SQL Server. Also it (and only it) allows you to work with SQL Server Express LocalDB databases.

Support for SQLite user authentication has been implemented (SQLite 3.8.7+).
Picture 6. SQLite connection options

In addition to above, several bugs have been fixed and some other minor improvements and corrections have been made. For more information about a specific tool see the appropriate page:

	Data Sync for MySQL		PostgreSQL Data Sync
	MS SQL Data Sync		Oracle Data Sync
	Firebird Data Sync		SQLite Data Sync
	DB2 Data Sync		MaxDB Data Sync
	ASA Data Sync

Back to news archive