All geek questions in one place

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

Does anyone know what would be the best way to convert a large SQL Server database to SQLite or SQL Server Compact?

The SQL Server database should be around 50-70 GB.

There are several examples on the Internet (scenario diagram), but I did not find anything in common with the data.

+8
source share
3 answers

You can use the Exportsqlce tool to create sqlite .sql files 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 the GUI)

+16
source

9.1, unfortunately it is in Italian. Several times I tried to install VSIX unsuccessfully (it says “success”, but I don't see anything new in menus, copying, or exporting). In any case, I'm not sure that this tool can do what I need: I want to extract some of the data (filtered out) with the same structure or the entire database from SQL Server 14.0.2014.14 into SQLite. Is it possible? Is this the right tool for this? What can I do to solve the problem and get what I need? Any suggestion?

0
source

slq db is successfully converted to sqlite. but it did not create any triggers. I used the command line Export2SqlCe.exe, by the way.

0
source

Source: https://habr.com/ru/post/1203470/

More articles:


All Articles