convert sdf to mdf

Question

I have this sql ce database which I would like to convert to SQL 2008 because I want it to be accessible through the network. I am using SQL 2008 express; and VB9.

Any idea?

Answer 1

A simple way would be to go into SQL Management Studio (I think it can connecto to SDF files?) and right click on it and in actions there will be a script database to text file. That will give you SQL scripts to create the schema, then you can create them in SQL 2008.

Answer 2

I dont think so that you can connect management studio to .sdf files. i did not found any option.

Answer 3

It all depends on which version of SQL Server Management Studio you using. If you using the SQL Server 2005 Management Studio Express, make sure you download the one with Service Pack2 from this link and not this one. The full version of Management Studio 2005 does support sdf files. I can't comment on the 2008 Express version though.