How can update SQL server after adding some additional feature in C# application

Question

0.00/5 (No votes)

See more:

Hi Every one.
I Complete my Project And my client use my software now I'm Add some new Features in my application so My database Tables And store procedures are increase.
Now Any One tell me How can i Add new database in clint computer and Clint Previous Data Remain Save.
Please Help me Thanks
I'm using c# Application with sql server database

What I have tried:

I have no idea how can i do this

Posted 29-Jul-18 5:00am

Fahid Zahoor

Updated 29-Jul-18 5:39am

Add a Solution

Comments

Richard MacCutchan 29-Jul-18 11:12am

You need to write a conversion process. Although it is a bit late to be thinking about this.

Fahid Zahoor 29-Jul-18 11:57am

you tell me the solution,i use it in my next project you just explin me how can i do this thanks

Richard MacCutchan 30-Jul-18 3:10am

Create a new table with the extra column then copy the data from the old table to the new one record by record.

2 solutions

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)

Mike V Baker · Answer 1 · 2018-07-29T05:17:00

Redgate makes products that you can use for this. There's RedGate SQL Compare that enumerates the schema, views, & SP and compares them with the same from another database. For this to work you need to have access to both PC's at the same time (I do this with my clients with LogMeIn Hamachi).
I believe RedGate also has a Database Installation project template. If I remember right you allow the wizard to access your database and it has a code generator to create the db on the client side.
As for making sure the data on the client side remains safe... this should be automatic. You should always have some backup system in place at all time. Most of my clients have daily backups. If I want a snapshot just before the installation then I usually handle that manually using SSMS (again through the LogMeIn Hamachi connection).
Also - you should have source control snapshots of your schema.

Mike

Gerry Schmitz · Answer 2 · 2018-07-29T05:40:00

https://www.c-sharpcorner.com/article/create-a-sql-server-database-dynamically-in-C-Sharp/

.net - How to use C# to add a column for a table of sql server? - Stack Overflow[^]

.net - How to backup Sql Database Programmatically in C# - Stack Overflow[^]

How to restore SQL Server database through C# code - Stack Overflow[^]

How can update SQL server after adding some additional feature in C# application

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0