DBSync for SQLite & MySQL

DBSync for SQLite & MySQL is a reliable bi-directional database migration tool which allows you to synchronize and convert from SQLite to MySQL or from MySQL to SQLite with the ability to copy the whole database as well as to convert particular tables, fields, indexes and foreign keys by simple configuring of several options through a Wizard interface or in command line mode.

DBSync for SQLite & MySQL helps to keep your databases up-to-date thanks to Insert-synchronization, Update-synchronization and Drop-synchronization features. Together they allow keeping distributed databases in agreement by accomplishing overall synchronization. The program includes utilities meant for
comparison and synchronizing data in different databases and for comparison of Identical, Different, Missing and Additional records.

DBSync for SQLite & MySQL includes Unicode support as well as a large number of other useful features. The Scheduling feature is a separate stage in the synchronizer Wizard allowing you to easily assign conversion and synchronization tasks with a single mouse click. With the integrated Data Mapping feature,you can easily match one data type to its closest and relative equivalent in the target fields. Customizable data filtering enables you to automatically create a new filter and easily modify an existing query. Preverification of possible conversion errors allows detecting probable troubles before the conversion process gets started. The program displays errors and potential problems with your table objects before you even start.

Improved general functionality, high speed of synchronization and stability of the software make DBSync for SQLite & MySQL product stand out from the crowd of similar data conversion tools.

Features
• Interactive (GUI) mode / command line mode;
• SQLite version 3.0 and higher support;
• SQLite database size optimization;
• Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for MySQL 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;
• 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;
• Insert-synchronization, Update-synchronization and Drop-synchronization available
• Advanced customization options:
- partial selection for database objects to be converted.
- database objects (tables, fields, indexes) renaming before conversion.
- detection of possible conversion errors at customization stage.
• Sessions support - all your settings can be saved and restored then.
• `ENUM` and `SET` MySQL database types support;
• ‘Binary picture` SQLite data types support;
• Ability to connect to MySQL database servers located on all Unix-like and Windows machines.
• Skins support;
• 1-year free upgrades.

Requirements| Convert SQLite to / from MySQL
• Necessary privileges to write into database on the target MySQL server (not obligatory)
• MySQL 4.x/5.x
• SQLite 3.0, later and earlier
• Microsoft Visual C++ 2008 x86 Redistributable package