Best way to export SQL Server database to sqlite (or SQL Server Compact) Best way to export SQL Server database to sqlite (or SQL Server Compact) sqlite sqlite

Best way to export SQL Server database to sqlite (or SQL Server Compact)


You can use my Exportsqlce tool to create .sql files in sqlite format from a SQL Server database. Then run them using sqlite3.exe

Download command line tools from https://github.com/ErikEJ/SqlCeToolbox/releases/tag/3.5.2

Export2SQLCE.exe "Data Source=(local);Initial Catalog=Northwind;Integrated Security=True" Northwind.sql sqlite

Good luck!

(I also have SSMS and VS extensions that allow you to do this from a GUI)