Convert .sdf database to .mdf database

Question

I have this SQL Server CE database (with more tables and data) which I would like to convert to SQL 2008 because I want use it in Server (application need to used by many). I am using SQL 2008 express and C#.

Please suggest how I can do this.

Answer 1

Have you tried the Data Migration Wizard?

Anyhow, you might find this interesting: http://exportsqlce.codeplex.com/

Original source:

http://bembengarifin-tech.blogspot.com/2008/08/generate-script-export-data-from-sql-ce.html