MS Access to SQLite Migration and Sync

We offer the tools created to simplify the process of migrating and synchronizing data from a Microsoft Access to SQLite database. You can export MS Access (.mdb or .accdb files) into new SQLite database or overwrite the contents of an existing SQLite database.

Many companies use MS Access databases for storing their business data. Actually Access databases works perfectly with small-sized databases and for limited number of users who have simultaneous access over network. But its usage is limited to Windows operating systems family.

SQLite would be a great option to extend your reach to many platforms beyond Windows (iOS, OSX, Android, Linux, etc.). It would be a good portable (non-server) alternative database system for replacement.

Some specific points about SQLite strengths:

• Both Access and SQLite allow redistributing their engines with applications.
• SQLite is a free, compact, embeddable SQL database engine.
• As mentioned above SQLite is cross-platform, so if your app needs to be distributed to many platforms then SQLite is a better choice.
• Tighter integration with SQLite database engine offers better performance and application redistributing may be easier.
• The dynamic typing in SQLite allows it to do things that are not possible in traditional strong typed databases.
• SQLite as an open-source database engine has more liberal redistribution rights. Basically you can do with it whatever you want.

Software employs an intuitive and informative wizard style user interface to simplify the migration process. The program easily handles huge databases and you can seamlessly convert database’s elements including tables, default values, indexes, relations, primary and foreign keys in an integrated, visual environment.

Use our built-in scheduler to run tasks automatically without having to do this manually every time.

Read here trial versions limitations

Product highlights

• Access queries to MS SQL, MySQL and PostgreSQL views conversion support
• MS Access Work Groups support
• Linked tables support
• SQLite version 3.0 and higher support
• SQLite database size optimization
• Speed conversion with Bulk and Quantization features
• Also see common features for all DBConvert tools

Requirements

• Access 2000 or higher
• Microsoft Visual C++ 2008 x86 Redistributable package
• Necessary privileges to write into network shared folder (LAN or VPN) where destination database SQLite resides