 |
| ||||
Synchronize and convert databases from Access to SQLite or from SQLite to 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 simple configuring of several options through Wizard interface or in command line mode!
DBSync for Access & SQLite is also applicable for Access database synchronization and migration to SQLite database or to another Access db. Moreover, DBSync for Access and SQLite is quite well for copying and synchronizing SQLite database with another SQLite database.
Get DBSync for MS Access & SQLite and try it for yourself to fully assess its capabilities!
Here are some key features of "DBSync for MS Access & SQLite":
· Interactive (GUI) mode / command line mode;
· Insert-synchronization, Update-synchronization and Drop-synchronization available;
· Database objects (tables, fields, indexes and foreign keys) remapping;
· Support for MS Access Work Groups;
· Efficient synchronization with Quantization features;
· Preverification of possible conversion/synchronization errors;
· 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 DBMS internal purposes) with a substitute symbol;
· Automation of synchronization process with task planner scheduler;
Unicode Support/Connection character sets support:
· Primary keys and Indexes support ;
· Foreign keys (relations) support;
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;
· BLOB, CBLOB SQLite data types conversion and synchronization support;
· `OLE Object` packages support;
· Global and specific field mapping
· Filters for conditional data migration and synchronization;
· Skins support;
· Office 2010 support.
Requirements:
· At least 32 MB of RAM
· Necessary privileges to write into network shared folder (LAN or VPN) where destination database (Access/ SQLite) resides.
· Access 97/2000/2003/2007/2010
· SQLite 3.0, later and earlier
· Microsoft Visual C++ 2008 x86 Redistributable packa ge
Limitations:
· allows you to process only the first 50 records of each table
· nag screen
Via: DBSync for MS Access & SQLite 1.0.4
