Do someone know what would be the best way to transform a big SQL Server database to sqlite or SQL Server compact ?
有人知道将大型SQL Server数据库转换为sqlite或SQL Server compact的最佳方法是什么?
SQL Server database should be around 50-70Gb.
SQL Server数据库应该在50-70Gb左右。
There are some examples on internet (script schema) but I didn't find anything concluding about data.
互联网上有一些例子(脚本架构),但我没有找到任何关于数据的结论。
Thanks.
1 个解决方案
#1
12
You can use my Exportsqlce tool to create .sql files in sqlite format from a SQL Server database. Then run them using sqlite3.exe
您可以使用我的Exportsqlce工具从SQL Server数据库创建sqlite格式的.sql文件。然后使用sqlite3.exe运行它们
Download command line tools from https://github.com/ErikEJ/SqlCeToolbox/releases/tag/3.5.2
从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)
(我还有SSMS和VS扩展,允许您从GUI执行此操作)
#1
12
You can use my Exportsqlce tool to create .sql files in sqlite format from a SQL Server database. Then run them using sqlite3.exe
您可以使用我的Exportsqlce工具从SQL Server数据库创建sqlite格式的.sql文件。然后使用sqlite3.exe运行它们
Download command line tools from https://github.com/ErikEJ/SqlCeToolbox/releases/tag/3.5.2
从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)
(我还有SSMS和VS扩展,允许您从GUI执行此操作)