从SQLCE 4迁移到SQL Server 2008

本文介绍了从SQLCE 4迁移到SQL Server 2008的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 因此，作为一个早期采用者，我已经开发了一个基于SQLCE4，ASP.Net MVC3和实体框架CTP5 （代码第一）基于由阅读引起的鲁莽的适应本公告。

现在应用程序正在投入生产，我们需要失去对SQL Server 2008和更高版本azure的支持。

Scott Gu提到工具很快就会出现支持这样的迁移，但我不知道我们是否还为时过早，以利用一条简单的路线。

任何人都做了吗？是否有简单的迁移路径？像Visual Studio中的MDF创建脚本选项吗？

解决方案

你看过 SQL Server Compact Toolbox 和 SQL Compact数据和模式脚本实用程序在codeplex？

它允许您将模式和数据脚本到.sql文件，这可以是在任何上下文中使用。它也可以用于DMS 用于SSMS脚本。

您可以使用结果脚本文档，编程脚本的SQL紧凑型数据库文件或将模式和数据迁移到SQL Server（Express）2005或更高版本

So, being an early adopter, I have developed an application based on SQLCE4, ASP.Net MVC3 and Entity Framework CTP5 (code first) based on a fit of recklessness induced by reading this announcement.

Now the application is moving into production and we need to lose the ce in favour of SQL Server 2008 and later azure.

Scott Gu mentioned that tooling would be out soon to support such migrations but I wonder if we're too early to take advantage of an easy route.

Anyone done it? Is there a simple migration path? Something like the MDF create script option in Visual Studio?

解决方案

Have you looked at SQL Server Compact Toolbox and SQL Compact data and schema script utility on codeplex?

It allows you to script schema and data to a .sql file, which can be used in any context. It also scripts DML for use in SSMS scripts.

You can use the resulting script for documentation, programmatic scripting of SQL Compact database files, or migration of schema and data to SQL Server (Express) 2005 or later