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

问题描述

我有4个要移到SQL CE的SQL Server 2005数据库.我知道我无法保留SProcs，Views和Functions( 之间的区别SQL 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.

我已经尝试过该应用，

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 Standard到SQL CE的复制.

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

推荐答案

查看全文