问题描述
我有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.
我已经尝试过该应用， 从SQL Server到SQL Server Compact Edition数据库副本 ，但我错了.我有资料来源，正在调查中，但是我想我要检查一下并确保我没有把解决方案复杂化到我的ACTUAL目标.
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.
推荐答案
http://erikej.blogspot.com/2010/02/how-to-use-exportsqlce-to-migrate-from.html
这篇关于将SQL数据库(mdf)迁移到SQL Compact Edition(sdf)的方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！