CODEWITHSUNDEEP
c#sql-server-2008sql-server-ce
Honey
Honey

Reputation: 163

Convert .sdf database to .mdf database

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.

Upvotes: 4

Views: 18111

Answers (5)

gkiko
gkiko

Reputation: 2289

This tutorial should help you. It shows you how to convert .sdf to .cs object using SQLMetal.exe

Upvotes: 2

Bob Reid
Bob Reid

Reputation: 11

Microsoft WebMatrix uses Compact SQL (.sdf file) by default. In the Database view, if SQL SVR is installed, there is a Migrate to SQL Server top menu item. There is also a menu selection to install SQL Server. Both WebMatrix and (a version of) SQL SVR 2008 are free to install.

Upvotes: 1

GameAlchemist
GameAlchemist

Reputation: 19294

Maybe a good idea is to try microsoft (free) tool, Sql Server Management Studio : http://www.microsoft.com/download/en/details.aspx?id=7593

Upvotes: 1

Alexander Zbinden
Alexander Zbinden

Reputation: 2541

You could use MSDeploy to migrate your database:

http://erikej.blogspot.com/2011/03/migrate-sql-server-compact-database-to.html

Upvotes: 0

Digvijay
Digvijay

Reputation: 361

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

Upvotes: 4

Related Questions