How to convert your .sdf into a .mdf file ?

Question

User-168876517 posted

Hi all,

 

I just figured out how to create a .SDF file out of an .CSV  and now I really like to know how to create a .MDF.

It doesn’t matter to me if I have to use the .SDF of the .CSV to start from as long as I got an .MDF on the end.

Hope you guys can help, kind regards,

Alfred

Answer 1

User-981899747 posted

1. Right-click on the sdf database from SQLCE Toolbox.

2. Select the "Script Database Schema and Data" option.

3. Save the generated script to a file.

4. Run the file from SQL Server Management Studio.

Answer 2

User-168876517 posted

Ok, but what is a SQLCE Toolbox? cant find it, sorry :(

Answer 3

User-821857111 posted

Download WebMatrix, turn to the Database workspace and use the Migrate button which will turn your sdf into an mdf.

http://www.microsoft.com/web/webmatrix/workspaces.aspx

Answer 4

User-981899747 posted

Ok, but what is a SQLCE Toolbox? cant find it, sorry :(

It's the tool you used to do the CSV import from the other thread.

Answer 5

User-168876517 posted

Is that all? I have tried but it makes a dbo.products file but a .mdf file is nowwhere to be seen?

Answer 6

User-981899747 posted

Right-click on the database node, not the Product table node.