将SQL Server数据库导出到sqlite(或SQL Server Compact)的最佳方法 [英] Best way to export SQL Server database to sqlite (or SQL Server Compact)

问题描述

有人知道将大型SQL Server数据库转换为sqlite或SQL Server compact的最佳方法是什么吗?

Do someone know what would be the best way to transform a big SQL Server database to sqlite or SQL Server compact ?

SQL Server数据库应在50-70Gb左右.

SQL Server database should be around 50-70Gb.

互联网上有一些示例(脚本模式)，但是我没有发现关于数据的结论.

There are some examples on internet (script schema) but I didn't find anything concluding about data.

推荐答案

您可以使用Exportsqlce工具从SQL Server数据库以sqlite格式创建.sql文件.然后使用sqlite3.exe

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

从https://github.com/ErikEJ/SqlCeToolbox/releases/tag/3.5.2

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

祝你好运！

(我也有SSMS和VS扩展，可让您从GUI执行此操作)

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

这篇关于将SQL Server数据库导出到sqlite(或SQL Server Compact)的最佳方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！