title: Converting MDF to SDF
body: <p>I've done a bit of Googling trying to find out how to convert a <code>.MDF</code> file to a <code>.SDF</code>. There doesn't seem to be much around apart from an old article for something called 'SQL Server to SQL Server Compact Edition Database Copy Utility'. As this is so old, I doubt it will work with the newer versions of SQL Server databases. Is there a more established and official method of achieving this now? Ideally I need something that will migrate the data as well as the table structures.</p>