 |
| ||||
DBConvert for SQLite and MS SQL is an efficient and comprehensive application that peforms conversion between SQ Lite and MS SQL databases.
The tool is also applicable for MS SQL database migration to another MS SQL database or to MS SQL server and is quite adept at copying a SQLite database to another SQLite database.
DBConvert for SQLite and MS SQL provides the bulk of functional capabilities such as interactive (GUI) mode/command line mode, saving data into a MS SQL Dump for export to MS SQL database, task planner scheduling, data mapping, data filtering, preverification of possible conversion errors, etc.
You can convert SQLite to MS SQL or MS SQL to SQLite simply by configuring several options through a Wizard interface or in command line mode.
Command line parameters added to a scheduling function enables you to automatically synchronize or convert data regularly without user input and supplementary settings.
DBConvert for SQLite and MS SQL provides you with the ability to create Dumps for indirect data uploading on MS SQL thereby offering a workaround to possible server restrictions.
Data mapping is a compatible data types assignment for a destination database. This function used as an additional ability for data population makes your conversion more flexible.
Filtering data during conversion allows users to retrieve only specific data for converted tables according to defined filtering criteria. Filters give you more control on the data migration process.
Possible conversion errors can be detected before the conversion process gets started. The tool displays errors and potential problems with your table objects beforehand.
Here are some key features of "DBConvert for SQLite and MSSQL":
· Interactive (GUI) mode / command line mode;
· Saving data into a MS SQL Dump and PHP script for export to MS SQL database;
· Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for DBMS internal purposes) with a substitute symbol;
· Automation of the conversion process with task scheduler;
· SQLite version 3.0 and higher support;
· SQLite database size optimization;
· Ability to select TCP/IP, PIPE, IPX/SPX communications protocols;
· Unicode (utf-8/ utf-16) for MS SQL Server support, all possible encoding support.
· Primary keys and Indexes support;
· MS SQL schemes support;
· Foreign keys support;
Advanced customization options:
· - partial selection for database objects to be converted;
· - database objects (tables, fields, indexes, foreign ke ys) tuning up before conversion;
· - detection of possible conversion errors on customization stage.
· Sessions support - all your settings can be saved and restored then.
· `Binary picture` SQLite data types support;
· Ability to connect to MS SQL database servers located on all Unix-like and Windows machines;
· Skins support;
· Multilanguage Support (English, French, Russian, German, Spanish, Italian, Greek and Danish);
Requirements:
· 32 MB RAM
· Necessary privileges to write into database on the target MS SQL server
Limitations:
· Allows you to process first 50 records of each table · 30-day trial
· Nag screen
What's New in This Release: [ read full changelog ]
· Added conversion for SQL Azure.
· Speed enhancement for better conversion. Large databases with 500 thousand records can be converted in 30-40 min.
· Stable conversion speed improvements. Now large databases are converted approximately in 100 times faster.
· Added Bulk insert feature for SQLite.
· Quantization added
Via: DBConvert for SQLite and MSSQL 1.5.0
