Backup SQL Server CE database with C# - Import-Export

Question

I have created a C# windows application with vs2010 and I'm using a SQL Server CE database. I'm looking for a way to backup my database programmatically.

Is there a way to export/import my entire database (as a .sdf file) or just copy it to another location and then import it and replace the current one?Could anyone provide me the code in order to do this?

I'm relatively new to this but I'm guessing this is not something as difficult as it sounds. I couldn't find a clear answer anywhere so any help would be appreciated!

ErikEJ · Accepted Answer · 2012-03-07 19:19:34Z

1

File.Copy will do the job, I believe. You can get the full path from the SqlCeConnection.Database property

edited Mar 7, 2012 at 19:19

answered Mar 7, 2012 at 16:36

ErikEJ

42.1k5 gold badges81 silver badges119 bronze badges

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

2 Comments

MarcusV Over a year ago

I read that before but i don't now how to make it work.can you give me an example?

MarcusV Over a year ago

I found how to make it work but i used an absolute path for database. I would like to use a relative path instead, for after deploying my application.How can i do this?

Collectives™ on Stack Overflow

Backup SQL Server CE database with C# - Import-Export

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related