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 stackoverflow.com Mar 4 '13 at 9:54

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

2  
Find the file - copy it - done! – marc_s Mar 4 '13 at 7:38
2  
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
1  
@Alzayed: It will tell you in the connection string. – leppie Mar 4 '13 at 7:46
1  
How to find the database path: See my blog post here: erikej.blogspot.dk/2013/02/… – ErikEJ Mar 4 '13 at 8:14

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.