4

I have created program that uses SQL Server database to store data. After a while (and lots of stored data) I have realized I don't need database on the server, local database running without server could do the job.

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

Improve this question
2
  • What's your primary motivation for moving away from SQL Server? Licensing? Reduced installation requirement? Something else? Commented Sep 26, 2011 at 13:50
  • Well that software is "from me for me" and i don't need MSSQL server running every time i start windows, i just don't want to worry about it if i can use compact DB Commented Sep 26, 2011 at 13:52

3 Answers 3

Reset to default
2

Check out the SQL Server to SQL Server Compact Edition Copy Tool available on CodeProject in C# source code:

enter image description here

Should do just what you need: copy data from SQL Server to a SQL Server Compact Edition .sdf file.

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

Can it work with MSSQL 2008? On screenshot you provided, latest supported version is 2005
@guest86: don't know - you can find the latest version here - ask the author!
Ok, you gave me a direct answer so i'll try your solution :)
0

Use the Export database tool? If you are using MS Windows OS then you can access is through the JET interface.

Improve this answer

Comments

0

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

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.