sql-server-2008-r2sql-server-ce

How to convert SDF file database to SqlServer Database

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.

Solution

  • 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