|
|
|
| Downloads: 889 |
 Tell us about an update
|
 |
|
User Rating:
Rated by: |
Excellent (5.0/5)
1 user(s) |
|
|
|
DBSync for SQLite & MySQL description
|
Bi-directional synchronization and conversion tool for SQLite & MySQL databases
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.
Get DBSync for SQLite & MySQL and take it for a spin to assess its capabilities! Here are some key features of "DBSync for SQLite & MySQL":
· 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
Requirements:
· At least 32 MB of RAM
· Necessary privileges to write into database on the target MySQL server
Limitations:
· Only 50 records will be processed What's New in This Release: [ read full changelog ]
· Variable quantization step added.
|
|
Find us on Google+
