现在应用程序正在投入生产,我们需要失去对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
更多推荐
从SQLCE 4迁移到SQL Server 2008
发布评论