将 SQL 数据库 (mdf) 迁移到 SQL Compact Edition (sdf) 的方法 [英] Methods to migrate SQL Database (mdf) to SQL Compact Edition (sdf)

问题描述

我有 4 个 SQL Server 2005 db，我想迁移到 SQL CE.我知道我无法保留 SProcs、视图和函数(Differences BetweenSQL Server Compact 和 SQL Server)，但我想保留其他所有内容.

I have 4 SQL Server 2005 db's that I want to move to SQL CE. I know I cannot keep the SProcs,Views, and Functions(Differences Between SQL Server Compact and SQL Server) but I would like to keep everything else.

我已经尝试过这个应用程序，SQL Server 到 SQL Server Compact Edition 数据库副本，但它在我身上出错了.我有来源并且正在调查它，但我想我会检查并确保我没有过度复杂化我的实际目标的解决方案.

I have tried this app, SQL Server to SQL Server Compact Edition Database Copy but it errors out on me. I have the source and am looking into it but I thought I'd check and make sure I wasn't over complicating the solution to my ACTUAL goal.

有没有一种简单的方法可以将标准 SQL .mdf 转换为 SQL CE .sdf?

Is there a simple, can be one shot, way of converting standard SQL .mdf to SQL CE .sdf?

现在我最好的想法是设置从 SQL 2005 标准到 SQL CE 的复制.

Right now my best idea is to set up Replication to the SQL CE from the SQL 2005 Standard.

推荐答案

http://erikej.blogspot.com/2010/02/how-to-use-exportsqlce-to-migrate-from.html

这篇关于将 SQL 数据库 (mdf) 迁移到 SQL Compact Edition (sdf) 的方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！