Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to move my running windows-based app (built in C#) to another machine, but I also need to transfer the whole data, how can I take a backup from the .sdf file and use it with the new installed app?

I tried to take a copy of the .sdf file, but I couldn't find it !

Any help ? ...

share|improve this question

migrated from Mar 4 '13 at 9:54

This question came from our site for professional and enthusiast programmers.

Find the file - copy it - done! – marc_s Mar 4 '13 at 7:38
How can you not find the .sdf file? That is like writing to /dev/null. – leppie Mar 4 '13 at 7:45
I tried to search any *.sdf in the whole machine but i couldn't find it !! – Alzayed Mar 4 '13 at 7:45
@Alzayed: It will tell you in the connection string. – leppie Mar 4 '13 at 7:46
How to find the database path: See my blog post here:… – ErikEJ Mar 4 '13 at 8:14

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.