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

Subscribe to our news:
Partners
Testimonials
Lucian Nedescu: "Thank you very much. Have a nice century (this is a real wish :P). I think that i will do a great job on my clients database with the new php interface. Thank You again".
David Lantz: "Thank you, this is by far the simplest, and most friendly utility for building db record system I have ever used. I wish I could get my systems guys at the office to purchase this for our company would be so very helpful and speed up a lot of work. I for one have used it for everything from a simple inventory record of my house, to a members record for my church just little pet projects and a test bed to test my own db builds and theories before having to hand code at the office..... it is a lot of fun to work with".

More

Add your opinion

Customers
SQL Maestro Group / Products / MySQL / 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
Back to news archive