• 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 http-tunnel can be used to access databases on webservers
• 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
• 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.
• Copy and sync operations can be scheduled with the windows scheduler
• NEW in V2: 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
• Technical information about copy and synchronize here
• This is the only software available wich transfers data between Access/SQLServer/MySQL, uses an http-tunnel and accepts UTF8 characters. Be ahead of your competitors!

• 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
  Links to update MDAC/JET: link 1, link 2, link 3
  Access components for ACCDB files: link 4
• For the PHP-tunnel: PHP >= 4.4

Architecture Diagram

Flowchart

Detailed Flowchart

Data Type Mapping between different databases