How to convert SDF file database to SqlServer Database

Question

I have a SDF file database (SQLCESerer Compact 3.5), I want to convert it to SqlServer database file using Sql Server 2008 R2.

Thank you so much.

Answer 1

Export data, create schema in sql server, import data.

Update: alternatively there are tools. Check the walkthrough at http://www.microsoft.com/web/post/migrate-a-database-to-sql-server