SyncTables

Copy and sync database tables MySQL/SQLServer/Access. http-tunnel
Download

SyncTables Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Free to try
  • Price:
  • $199.00
  • Publisher Name:
  • Donauweb IT Solutions
  • Operating Systems:
  • Windows 2000
  • File Size:
  • 656 KB

SyncTables Tags


SyncTables Description

SyncTables copies 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. An http-tunnel (or https) using PHP connects to MySQL-databases on webhosting servers. Using the Windows Scheduler, you can easily keep your local and remote databases synchronized at all times. 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. Main features: Synchronize (one way sync) tables based on an intelligent algorithm with a last-update column Hosted MySQL servers on the internet can be accessed via an http/https-tunnel Https server with private certificate can be accessed Http(s)-tunnel is realized with a simple PHP-script which works on almost every web host. Primary Keys are copied to the destination table, and data representation is preserved across all the database types Unicode/UTF8 compliant, so it transfers characters in any language 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. Copy and sync operations can be scheduled with the windows scheduler The target table can have a different name than the source table Copy operation copies to intermediate table then renames the destination table, this shortens the time that data is not available at the destination Detailed logfile written User interface for easy setup of data transfer Command line support makes it well suited for scripting


SyncTables Related Software