sqlitems sql

SQLite to MS SQL Migration and Sync

Conversion Tool for data migration and synchronization between SQLite and MS SQL databases in both directions. One of the main benefit of this converter is the range of effective features that help you to transfer all database objects together or each individually, skipping unnecessary tables, fields, indexes, foreign keys and constrains; change data types for various fields; rename each database element and many other options that assist you to customize the target database without any efforts. 

If you have any restrictions on direct access to MS SQL server our product provides you with the opportunity to create Dump files for further data uploading to MS SQL server.


If your SQLite database has increased to a large enterprise level db, you can always migrate your data to such dbms and MS SQL would be the best choice.  

The main advantages  MS SQ:

  • Solid system primary used for enterprise level database management
  • Good data recovery and scripting
  • Highly functional database with sophisticated features
  • Highly available as can be used by several users at the same time

The product comes both with fast and intuitive interface and command line support to speed up conversion of any previously saved session.

You can automate tasks export with Built-in Scheduler then application can be not launched because the scheduler runs as a service.

Product highlights

  • SQLite version 3.0 and higher support
  • SQLite database size optimization
  • Speed conversion with Bulk and Quantization features
  • 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
  • Also see common features for all DBConvert tools

Requirements

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

Converter from
SQLite to MS SQL

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

Synchronizer between
SQLite and MS SQL

  • 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 MS SQL to SQLite

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

SQLite to MS SQL: 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