Exporting from SQLite to SQL Server

sql-server database sqlite data-migration
Geoff Appleford picture Geoff Appleford · Oct 2, 2008 · Viewed 79.4k times · Source

Is there a tool to migrate an SQLite database to SQL Server (both the structure and data)?

Answer

swilliams picture swilliams · Oct 2, 2008

SQLite does have a .dump option to run at the command line. Though I prefer to use the SQLite Database Browser application for managing SQLite databases. You can export the structure and contents to a .sql file that can be read by just about anything. File > Export > Database to SQL file.

Related questions

Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to replace a string in a SQL Server Table Column

I have a table (SQL Sever) which references paths (UNC or otherwise), but now the path is going to change. In the path column, I have many records and I need to change just a portion of the path, but …

Read More