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

Subscribe to our news:
Partners
Testimonials
Dave Lantz: "I have to say that I simple love this product and its ease of use. I know that I have only tapped into about 20% of what it can do. In my business I come into a lot of contact with developers and I tell them all, that if they need an easy way to connect, report or work their databases they MUST check out your products".
Torstein Krogh: "Some time ago, I tested all available tools on the market for maintaining MySQL and MySQL Maestro came up on top. My opinion is that MySQL should offer it as a free tool for all paying customers! They have nothing today, and doing MySQL DOS commands is not getting any new customers".

More

Add your opinion

SQL Maestro Group / News / All company news / Data Syncs are updated to version 12.2

Data Syncs are updated to version 12.2

Feb 9, 2012

Prev Next

SQL Maestro Group is happy to announce the release of Data Sync 12.2, 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.

New features:

  • Starting with this version our software allows you to compare and synchronize the data represented by database views.
  • An automatic checking of table and column mappings has been implemented. Now Data Sync displays a warning message if you, for example, forgot to specify a comparison key or even mapped two columns with incompatible data types. For your convenience we have also added a button to remove all the pairs with critical errors in a single click.

    Automatic checking of table and column mappingsPicture 1. Automatic checking of table and column mappings

  • Now it is possible to setup a filter for the source and target data before the comparison to compare and synchronize only subsets of data.

    Setting a filter conditionPicture 2. Setting a filter condition

  • An ability of exporting comparison results to any of 18 available formats including Excel, HTML, XML, and CSV has been implemented. Get the complete comparison report in a few mouse clicks!

    Export of comparison resultsPicture 3. Export of comparison results

  • From now on Data Sync tries to sort the target tables automatically to avoid potential integrity violations. Of course it is also still possible to reorder the targets manually.

    Reordering targets manuallyPicture 4. Reordering targets manually

  • Also it becomes possible to short the list of comparison pairs hiding the identical objects (i.e. tables and views that contain only identical records).

In addition to this, 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:

Prev Next