Home > Documentation > SQLite to SQL Server

Command Line Version of SQLite to SQL Server Converter

To perform batch conversion or call conversion procedure from an automation script you can use console version of SQLite to SQL Server converter called L2MAGENT.EXE. Find this file in the installation folder. You can either run this tool directly from command line or call it from any script as well. The program supports the following command-line options:

--dest=...		MS SQL database name
--help		display help message and exit
--logfile=...		path to the logfile where execution traces will be written
--mode=...		how to process an existing MS SQL database (0 - overwrite the entire database, 1 - overwrite existing tables only, 2 - skip existing tables, 3 - merge)
--mssqlh=...		MS SQL server IP address or network name
--mssqlu=...		MS SQL user name
--mssqlp=...		MS SQL user password
--profile=...		path to a profile to load conversion settings from
--silent		use this option to disable program output
--src=...		path to SQLite database
--tab_def		convert table definitions only
--tab_file=...		file containing table names to convert (one table name per line)

In the following example the program converts SQLite database located in "c:\db 1.sqlite" folder into MS SQL database "db 1" on the remote MS SQL server "EXAMPLE":

L2MAGENT.EXE --src="c:\db 1.sqlite" --dest="db 1" --mssqlh=EXAMPLE --mssqlu=scott 
--mssqlp=tiger

Notes:

You can omit 'mssqlh' to connect local database server
You can omit 'mssqlu' and 'mssqlp' parameters to connect to MS SQL server using Windows authentication
If you omit 'tab_file' parameter, all database tables will be converted
If you omit 'mode' parameter, default mode 'overwrite the entire database' will be used
Command line parameters that contain spaces should be enclosed in quotes (for example --dest="my database")