Microsoft SQL Server to SQLite Migration.

 DBConvert for SQLite & MSSQL

Version: 1.5.8

Release Date: March 17, 2015

Conversion directions:

  • SQLite → MS SQL Server, MS SQL Dump
  • SQL Server → SQLite, MS SQL Dump
  • SQLite ↔ SQL Azure
  • SQLite ↔ Amazon RDS
 DBSync for SQLite & MSSQL

Version: 1.4.6

Release Date: Nov. 19, 2014

Synchronization directions:

  • SQLite ↔ Microsoft SQL Server
  • SQLite ↔ SQL Azure
  • SQLite ↔ Amazon RDS

DBConvert/ DBSync are high performance two-way database migration and synchronization applications to convert and sync your Microsoft SQL Server to SQLite and vice versa. Windows Azure SQL Databases may be set up as a source or destination of migration process.

Feature list of our tools:

Nowadays, data transferring to SQLite is becoming increasingly popular for many reasons. If, for example, you need to store part of data of a large database in a small one, SQLite will fit perfectly to your needs.

SQLite is commonly used in business applications, mobile devices and iOS applications and suitable for small data management systems. It is more portables because is serverless – data is stored in one database file, cross-platform and can be run on many platforms.

You can easily synchronize even an existing remotely hosted MSSQL database to both local and remote SQLite databases using our software solutions. Very intuitive interface and effective features certainly help you export data in little time.

Product Highlights

  • MS SQL Server Express 2005/2008/2008 R2/2012, MS SQL Server 2000/2005/2008/2008 R2/2012, SQL Azure support
  • Amazon RDS SQL Server DB Instance support
  • SQLite version 3.0 and higher support
  • SQLite database size optimization
  • Saving data into a MS SQL Dump for export to MS SQL database
  • Speed conversion with Bulk and Quantization features
  • Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL
  • Speed conversion with Bulk and Quantization features
  • MS SQL schemes support
  • Views conversion from MS SQL to MySQL and Oracle and back support
  • Ability to select TCP/IP, PIPE, IPX/SPX communications protocols

Interface languages

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

Product Requirements

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

Latest News

  • Parameterized queries improved. Synchronization/conversion speed increased approximately by 15%.
  • Speed enhancement for better conversion and synchronization. Large databases with 500 thousand records can be converted/synchronized in 30-40 min.
  • Added Bulk insert feature for SQLite.
  • Quantization added.