从SQL到SQL CE:如何读取SQL或Access数据库并将其写为SQL CE数据库? [英] SQL to SQL CE: How to read an SQL or Access database and write it out as SQL CE database?

问题描述

我的MS SQL数据库(或Microsoft Access)中只有一个简单的表.如何读入该表并将其写为SQL CE数据库?我同时安装了Visual Studio和WebMatrix，因此可以根据需要使用这些工具之一.谢谢.

I have just one simple table in my MS SQL database (or Microsoft Access). How do I read in this table and write it out as an SQL CE database? I have both Visual Studio and WebMatrix installed so I can use either of these tools if required. Thanks.

是否可以将一个表复制并粘贴到另一个表?如果可行，这将是最简单的方法.

Is it possible to copy and paste one table to another? This would be the simplest if it works.

推荐答案

尝试使用我的Visual Studio加载项，允许您从SQL Server迁移到SQL Server Compact:

Try my Visual Studio add-in, allows you to migrate from SQL Server to SQL Server Compact: http://sqlcetoolbox.codeplex.com - command line walkthrough here: http://erikej.blogspot.com/2010/02/how-to-use-exportsqlce-to-migrate-from.html

这篇关于从SQL到SQL CE:如何读取SQL或Access数据库并将其写为SQL CE数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！