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

Subscribe to our news:
Partners
Testimonials
Grey: "

We're a two-person company, it's just me an my wife. I'm the technical guru, and she handles the business operations. I have to know a lot about MySQL, but that's much too technical for her. I have frequently had to setup CGI scripts (I code in Perl) so she can manage some of our tables (suppliers, manufacturers, etc).

I discovered PHP Generator a couple of days ago, tried the free version,and within a few hours I had purchased the Pro version (as well as SQL Maestro for MySQL).

Today I am completing the conversion of the last of my custom table managers to PHP Generator. This is eliminating several thousand lines of code that I don't have to support any more!

Thanks for this fantastic product".

Charles Phillips: "I very much like the program and all of its functionality! Would be happy to give you an endorsement or recommend it to others - saves me a ton of time".

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