SyncTables 2.0.9

SyncTables 2.0.9 offers you a great tool which can allow you to copy database tables between MySQL, MS SQLServer and Access. Table structure and data is copied. Strings are transferred correctly using UTF8.

Tables can be copied completely or only modified records are transferred. The Oneway synchonization only transfers modified records from source to destination based on an intelligent algorithm with a last-update column. An http-tunnel (or https) using PHP connects to MySQL-databases on webhosting servers.

With the windows scheduler local and remote databases can be kept synchronous easily.

A graphical user interface with a wizard helps in creating an XML-configurationfile to define source and target database, tables to copy or synchronize and various options. The main program is a commandline program which reads this XML-file. A DTD to change the XML-file manually is available.

Major Features:

1. Synchronize (one way sync) tables based on an intelligent algorithm with a last-update column
2. Hosted MySQL servers on the internet can be accessed via an http/https-tunnel
3. Https server with private certificate can be accessed
4. Http(s)-tunnel is realized with a simple PHP-script which works on almost every web host.
5. Primary Keys are copied to the destination table, and data representation is preserved across all the database types
6. Unicode/UTF8 compliant, so it transfers characters in any language
7. NEW in V2: Custom database commands can be executed in the source and in the target database before and after synchronizing. When an http-tunnel is used a PHP includefile can be executed.
8. Copy and sync operations can be scheduled with the windows scheduler
9. NEW in V2: The target table can have a different name than the source table
10. Copy operation copies to intermediate table then renames the destination table, this shortens the time that data is not available at the destination
11. Detailed logfile written
12. User interface for easy setup of data transfer
13. Command line support makes it well suited for scripting
14. Technical information about copy and synchronize here
15. This is the only software available which transfers data between Access/SQLServer/MySQL, uses an http-tunnel and accepts UTF8 characters. Be ahead of your competitors!
16. Copy tables

• Access to MySQL and MySQL to Access
• MS SQLServer to MySQL and MySQL to MS SQLServer
• MySQL to MySQL
• From and to MySQL an ttp-tunnel can be used to access databases on webservers

Enhancements:

• Copy database tables,
• Synchronize database tables,
• Http-tunnel

Requirements:

• MySQL 4.1 and 5.0; for tunneling PHP >=4.4,
• Microsoft SQL Server 2005,
• Microsoft Access 2003 and 07
• Windows 2000 or above, including Windows XP, Windows Vista, Windows Server 2003
• .NET Framework 2.0
• For Access: an up to date version of MDAC and JET

WareSeeker Editor