DBSync for MS Access & MySQL 5.1.0

This program allows you to easily convert and syncronize Microsoft Access (MDB) databases to MySQL and vice versa. DBSync for Access & MySQL Sync helps you synchronize and convert databases from MS Access to MySQL or from MySQL to MS Access fast!
DBSync for Access & MySQL is a reliable bi-directional database migration tool which allows you to synchronize and convert from:
- MS Access to MySQL
- MS Access to MS Access
- MySQL to MS Access
- MySQL to MySQL.
Synchronize and convert databases from MS Access to MySQL or from MySQL to MS Access rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed! Reach the desired result by simply configuring of several options through Wizard interface or in command line mode!
DBSync for Access & MySQL is also applicable for MySQL database synchronization and migration to another MySQL database or even to another MySQL server. Moreover, DBSync for Access & MySQL is quite well for copying and synchronizing MS Access database with another MS Access database.
High speed data conversion and performance
Try it now and make sure that it’s true! DBSync for Access & MySQL establishes a direct connection to source and destination databases. Thanks to improved quality of synchronization, data is transferred much faster and more accurate in comparison with lots of universal synchronizers which use ODBC or ADO. It is developed exactly for solving your problem with minimum effort and time!
Safe data conversion and database integrity
Don’t care about safety of your data. Our converter will do it for you! DBSync for Access & MySQL supports all MySQL server and MS Access data types (including `BLOBS` and `OLE Object` packages). Primary keys, indexes and foreign keys (relations in MS Access) are supported in the best way.
Update, Insert and Drop synchronization
Keep all your databases up-to-date. Insert synchronization is meant for new records adding from a source to a destination database. Update synchronization is meant for replacing of the altered records in destination database. Drop-synchronization allows users to delete records from destination database if these records were removed in source. Together they allow keeping distributed databases in agreement.
Database objects (tables, fields, indexes and foreign keys) remapping for synchronization
Synchronize databases with different structures easily! All database objects (fields, indexes and foreign keys) can be remapped on the customization stage.
Full UNICODE architecture support
DBSync for Access & MySQL is based on full Unicode architecture with multibyte character sets support. It is compatible with a lot of character sets (including Unicode utf-8) and associated standards.
Customize your data synchronization process and database copying totally
Synchronize databases with identical or even with different structures! All customizations are organized on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.
Savable sessions
Save your sessions and use them again if you do not want to loose time for configuring source, destination database and other customizations for conversion process.
Command line mode
Run DBSync for Access & MySQL as a part of your automate solution to activate it from a command line with saved session name as a parameter.
Effective scheduler
Automate running of your DBSync for Access & MySQL by using Data Conversions Scheduler! Convenient scheduler is available for all data converters, so you can run the program without user input after having scheduled it once.
User-friendly interface
User-friendly interface is the outcome of the combined efforts of our team in the field of software usability plus Graphic User Interface design. Working with the converter is specially divided into several stages so the most complex issues of the conversion process are broken down into manageable parts. All documentation is provided with the software for your convenience.
Main features:
- Insert-synchronization and Update-synchronization available;
- Database objects (tables, fields, indexes and foreign keys) remapping;
- Interactive (GUI) mode / command line mode;
- Support for MS Access Work Groups;
- Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for DBMS internal purposes) with a substitute symbol;
- Automation of the conversion and synchronization process with task planner scheduler;
- Ability to select ISAM, MYISAM, HEAP, InnoDB or BDB table types when copying data to MySQL;
- High speed data conversion and synchronization. DBSync for Access & MySQL speed noticeably exceeds average showing in this category as the program works with direct access to MySQL server not through ODBC like other similar converters;
- Unicode Support/Connection character sets support: LATIN1, LATIN2, LATIN5, LATIN7, ARMSCII8, ASCII, CP1250, CP1251, CP1256, CP1257, CP850, CP852, CP866, DEC8, GEOSTD8, GREEK, HEBREW, HP8, KEYBCS2, KOI8R, KOI8U, MACCE, MACROMAN, SWE7, TIS620, UTF8 (unicode charset);
- Primary keys and Indexes support;
- Foreign keys (relations) support;
Advanced customization options:
- partial selection for database objects to be converted or synchronized;
- database objects (tables, fields, indexes, foreign keys) tuning up before synchronization;
- detection of possible conversion and synchronization errors on customization stage.
- Sessions support - all your settings can be saved and restored later;
- `ENUM` and `SET` MySQL database types support;
- `GUID` Access database type support;
- `OLE Object` packages support;
- Skins support;
- Multilanguage Support (English/French/Russian);
- 1-year free upgrades.
System requirements:
- At least 32 MB of RAM
- Necessary privileges to write into database on the target MySQL server
Version restrictions:
- Does not convert system (hidden) tables.
- The demo version converts only 10 initial records for each database.