SQLite to MySQL Migration.

 DBConvert for SQLite & MySQL

Version: 1.8.2

Release Date: Sept. 12, 2015

Conversion directions:

  • SQLite → MySQL, MariaDB, MySQL Dump, PHP Script
  • MySQL, MariaDB → SQLite, MySQL Dump, PHP Script
  • SQLite ↔ Amazon RDS
 DBSync for SQLite & MySQL

Version: 1.5.5

Release Date: Sept. 12, 2015

Synchronization directions:

  • SQLite ↔ MySQL ↔ MariaDB
  • SQLite ↔ Amazon RDS

DBConvert and DBSync for SQLite and MySQL provide reliable and effective way of database conversion and synchronization in two ways - from SQLite to MySQL server and vice versa.

Using software you can move not only the entire database but it is possible to configure migration of each element separately.

Interactive (GUI)/ command line mode, built-in task planner, data filtering, detection of possible errors, data mapping are among the other features of Conversion/ Sync software for SQLite and MySQL.

The tool combines an intuitive interface with powerful and useful features to transfer SQLite file to local or remotely hosted MySQL databases in a short time. In additional to the conversion directly to MySQL server, you can also move data to PHP script or Dump file in case the direct access to the server is restricted.

All your entries for databases connections are automatically saved in a ‘session’. During a next loading of the saved session, you go directly to Customization step as all of your connection settings to the source and destination dbs are kept and there is no need to type them all over again.

Product Highlights

  • SQLite version 3.0 and higher support
  • Saving data into a MySQL Dump and PHP script for export to MySQL database
  • Speed conversion with Bulk and Quantization features
  • Ability to connect to MySQL Server 4.x/5.x located on Linux, Solaris, Mac OS X, Windows machines
  • Views conversion from MySQL to MS SQL and Oracle and back support
  • Amazon RDS MySQL DB Instance support
  • SQLite database size optimization

Interface languages

English German French Spanish Italian Danish Chinese Russian Portuguese Polish Greek Bahasa

Product Requirements

  • Necessary privileges to write into network shared folder (LAN or VPN) where destination database SQLite resides
  • Necessary privileges to write into database on the target MySQL server (this requirement is optional as there is an option to overcome the restrictions using dump file or PHP Script)

Latest News

  • Conversion/Synchronization speed-up for large databases with 500 thousand records and more. Now they can be convert/synchronized in 3-5 min.
  • Bulk insert feature for SQLite added.
  • Variable quantization step added.