Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
SQL Maestro Group / Products / MS SQL Server / MS SQL Data Sync / News / Data Sync advanced to version 15.3

Data Syncs advanced to version 15.3

Mar 16, 2015

Prev Next
Data Sync

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.

    Data comparison optionsPicture 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.

    Synchronization optionsPicture 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.

    Progress WindowPicture 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.

    SSH Options: keyboard interactive authenticationPicture 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.

    Create Database Wizard: selecting a providerPicture 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.
    ValueSQL Server clientIntroduced with
    SQLOLEDBMicrosoft OLE DB Provider for SQL Server (default value)Comes with Windows
    SQLNCLISQL Server Native ClientSQL Server 2005
    SQLNCLI10SQL Server 2008 [R2] Native ClientSQL Server 2008 [R2]
    SQLNCLI11SQL 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+).

    SQLite connection optionsPicture 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 Data Sync for MySQL PostgreSQL Data Sync PostgreSQL Data Sync
MS SQL Data Sync MS SQL Data Sync Oracle Data Sync Oracle Data Sync
Firebird Data Sync Firebird Data Sync SQLite Data Sync SQLite Data Sync
DB2 Data Sync DB2 Data Sync MaxDB Data Sync MaxDB Data Sync
ASA Data Sync ASA Data Sync    
Prev Next