Click here to Skip to main content
15,919,613 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello gyus im facing a problem and i cant find the answer yet, i created a program in Visual Studio 2012 with an internal database (Service Based Database)- that will work as a local database, after installing it in my Clients PC (i also installed SQL EXPRES 2008 and SQL LOCAL DB in clients pc), he wanted me to make some changes in the program, now im facing a problem how to Backup the saved data on the Program, because i cant update the program, i must uninstall it and install it again.

ive searched all the forums but still nothing useful found yet, so pls someone help me.

1 solution

You want to make a setup with database? check this
How to deploy C# windows application With Sql Server?[^]

Or you want to give him an update to do changes in existing database? Couple of ways
0) Make a database script file & you could directly execute that
1) Create a batch file & execute the database script using sqlcmd Utility[^]
2) Make a simple UI form which connects the existing database, in button click call the execute database script file

Now you decide which one is secure/better for you.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900