Convert SQL Server Database to C # Local Database

Question

I created a program that uses a SQL Server database to store data. After some time (and a lot of saved data), I realized that I do not need a database on the server, a local database working without a server can do this job.

Now I need advice on how to export, convert, or whatever, a SQL Server database to a local (sdf) database? I am using VS 2010 and SQL Server 2008, I also have SQL Server Management Studio.

Answer 1

Check out SQL Server for SQL Server Compact Edition Copy Tool , available in CodeProject in C # source code:

It should do exactly what you need: copy data from SQL Server to the SQL Server Compact Edition .sdf file.

Answer 2

Use export database tool? If you are using MS Windows, you can access it through the JET interface.

Answer 3

Use my Export2sqlce.exe command line utility: http://erikej.blogspot.com/2010/02/how-to-use-exportsqlce-to-migrate-from.html