title: Methods to migrate SQL Database (mdf) to SQL Compact Edition (sdf)
body: <p>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(<em><a href="http://msdn.microsoft.com/en-us/library/bb896140.aspx" rel="nofollow noreferrer">Differences Between SQL Server Compact and SQL Server</a></em>) but I would like to keep everything else.</p>
  
  <p>I have tried this app, <strong><em><a href="http://www.johnnycantcode.com/page/SQL-Server-to-SQL-Server-Compact-Edition-Database-Copy.aspx" rel="nofollow noreferrer">SQL Server to SQL Server Compact Edition Database Copy</a></em></strong> 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.</p>
  
  <p>Is there a simple, can be one shot, way of converting standard SQL <code>.mdf</code> to SQL CE <code>.sdf</code>?  </p>
  
  <p>Right now my best idea is to set up Replication to the SQL CE from the SQL 2005 Standard.</p>