ms sqlsqlite

MS SQL to SQLite Migration and Sync

SQLite to MS SQL is a high performance two-way database migration and synchronization tool. Utility has all features required to satisfy your SQLite and MS SQL import and export needs.

Using these features you can:

  • Move local and remote databases
  • Import/Export full database or select specific its elements for conversion
  • Insert/Update/Delete only the required data  
  • Modify existing tables/field/field types/indexes/foreign keys
  • Apply a filter to retrieve only specific data you need for migration and synchronization

Command Line and Scheduler support can help you to automate any synchronization process.

Nowadays, data transferring to SQLite is becoming increasingly popular for many reasons. If, for example, you need to store some data of a large database in a small on, SQLite will fit perfectly to your needs as it is not intended to store large amounts of data.

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.

Using our converter you can not only move data to SQLite but also import/export data from SQLite to MS SQL and back.

By means of this reliable and powerful tool, you can easily synchronize even an existing remotely hosted MS SQL database to both local and remote SQLite databases. Very intuitive interface and effective features certainly help you export data in little time.

Product highlights

  • Views conversion from MS SQL to MySQL and Oracle and back support
  • Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL
  • MS SQL Server Express 2005/2008/2008 R2/2012, MS SQL Server 2000/2005/2008/2008 R2/2012, SQL Azure support
  • MS SQL schemes support
  • Saving data into a MS SQL Dump for export to MS SQL database
  • Ability to select TCP/IP, PIPE, IPX/SPX communications protocols
  • Speed conversion with Bulk and Quantization features
  • 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

  • MDAC 2.8
  • 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)
  • Necessary privileges to write into network shared folder (LAN or VPN) where destination database SQLite resides
MS SQL SQLite

Converter from
MS SQL to SQLite

  • 8 May, 2014
  • Version 1.5.6
ORDER From $ 149 DOWNLOAD 21.65 Mb

Synchronizer between
MS SQL and SQLite

  • 8 May, 2014
  • Version 1.4.5
ORDER From $ 149 DOWNLOAD 23.3 Mb

Two-way database migration in one package. Pay once - get both! Find more information about the reverse migration

From SQLite to MS SQL

Converter+Syncronizer Bundle! Take 25% off regular price

New Features

  • 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.

Screenshots

MS SQL to SQLite: Benefits

  • 1 - Workaround for firewalls and access rights
  • 2 - Views conversion
  • 3 - Flexible customization for all db elements
  • 4 - Bulk and quantization for speed up of big volume of data processing
  • 5 - Conditional data migration
  • 6 - Full UNICODE architecture support
  • 7 - Optimal data mapping
  • 8 - Verification of potential migration issues
  • 9 - Command line mode & scheduling
  • 10 - Savable sessions