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

Subscribe to our news:
Partners
Testimonials
Peter Robinson: "As a tech savvy company director, I wanted an inexpensive web based database application to manage all aspects of my business. As with most humans I find developing purely by CLI very hard and do not have the will or time to invest in improving my skills. I was looking to find a nice human friendly GUI to design and build my application, which is when I came across PHP Generator for MySQL.

Whilst you still need a great understanding of logic and a small amount of programming ability to get the specific results you require, I am very happy with the speed of progress I have been making with this invaluable tool.

With all the standard libraries included, this product makes normal requirements such as JavaScript form validation, lookup selectors, on click events, auto complete, detailed searches, multiformat exports, rss feeds and username security straight forward and quick.

Having any changes made via the GUI written to the web server at the click of a button makes testing out ideas quick and easy without fear of breaking your application.

To conclude, I couldn't find any other product on the market that came close to offering the amount of options this does, and I do hope that more products like this come out in the future, with the hope of eventually eradicating the need to program all together".

Alex Torin: "Several months ago I downloaded the trial versions of several Microsoft SQL administration tools that I was able to find using google. I had considerable trouble with most of them crashing... but using your product I was able to isolate and solve the problems I was having. I decided to add it to my toolkit and have recommended it to a few others".

More

Add your opinion

SQL Maestro Group / News / All company 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