如何在SQL Compact Edition中导入数据？ [英] How to import data in SQL Compact Edition?

问题描述

我似乎找不到它的工具，也不是odbc驱动程序。

I don't seem to find a tool for it, nor an odbc driver.

谢谢

更新：我知道sql脚本编写的可能性。但不止于此：如何编写sql 2k表的脚本？ （不仅仅是ddl，还有数据吗？）

UPDATE : I'm aware of the sql scripting possibilities. But than again : how to script a sql 2k table? (not just ddl, but data also?)

当然你可以自己写这些，但是将数据导入CE不是那么麻烦，还是可以呢？

Of course you can write this all by yourself, but importing data into CE cannot be such a hassle, or can it ?

UPDATE2：我似乎无法选择正确的方言来插入

UPDATE2 : I don't seem to be able to choose the right dialect for inserting

推荐答案

您可以使用 SQL Server Management Studio Express ，它还允许连接到SQL Compact数据库。然后，您就可以轻松执行任何具有从其他地方导出数据的* .sql文件。

You can use SQL Server Management Studio Express which also allows the connection to SQL Compact databases. You'll then be able to execute any *.sql file easily that have data exported from elsewhere.

编辑（对更新的响应）：我不知道您是否可以使用SSMS 2008连接到SQL Server 2000，但如果可以，请右键单击SSMS中的数据库，选择任务>生成脚本，然后在第二页的选项中向下滚动并更改脚本数据为真。

Edit (response to update): I don't know if you can connect to a SQL Server 2000 with SSMS 2008, but if you can, right click on your database in SSMS, choose Tasks > Generate Scripts, and in the options on the second page, scroll down and change "Script Data" to True.

这篇关于如何在SQL Compact Edition中导入数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！