How to Update an existing winform application setup and its database

Question

5.00/5 (1 vote)

See more:

I have a windows forms application written in VS.NET 2010 with sql server. This application is installed on my system. Now i want to update some features in this setup means add some functionality. and make some changes in db (mdf) file also. how can i do this .

just like version updated.

Hello
Thats what I am looking for.

When i Create setup of my application there is an option remove existing version in properties. This is replace existing version of my application but it also replace database file. How i handle this problem. I have also changes in database.(like add some tables, procedures etc).

Posted 11-Mar-15 0:22am

ErBhati

Updated 11-Mar-15 2:02am

v4

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

phil.o · Answer 1 · 2015-03-11T02:06:00

Solution 1

To update your executable/libraries, you must have the source code, that you can update and then recompile. It will give you new updated executable/libraries.

For your database, you have to create some script(s) that will update your existing database's schema.

Then you have to create a new deployment package that will :
- replace the old exutable/libraries with the new one(s)
- execute the SQL script(s) against the existing database to update its schema without loosing current data.

Posted 11-Mar-15 2:06am

phil.o

Comments

ErBhati 11-Mar-15 8:19am

Hello Phil
Thanks for your reply. but i am using mdf file of database which is inside my application. then how i can update schema of database. if you have any solution please reply.

phil.o 11-Mar-15 8:25am

That does not change the process. Having a mdf file or using a service is the same : you have to execute your SQL update scripts against the database. Where this database is stored and how it is accessed is not relevant. If your application can access the database, then you can access it also, and execute scripts against it.

ErBhati 11-Mar-15 8:51am

thanks again. I'll try it.