Solved

C# Install and Make Database Changes

Posted on 2016-07-26
4
62 Views
Last Modified: 2016-09-06
Working on a Winforms application.  Will be utilizing an installation program to install the app on a client.  

My question is, is there a tool that can compare the database and make changes to the database from the install application.  Looks like I will be using InstallShield for my installer.

Thanks
0
Comment
Question by:CipherIS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 20

Accepted Solution

by:
Russ Suter earned 500 total points
ID: 41729591
You would need to leverage the SQL Server Management Objects (SMO) library.
https://msdn.microsoft.com/en-us/library/ms162169.aspx?f=255&MSPPError=-2147217396
There's a lot in there. What you want to do is not impossible but may take considerable effort depending on how complex your database is.
1
 
LVL 1

Author Comment

by:CipherIS
ID: 41734955
Any other suggestions?
0
 
LVL 20

Expert Comment

by:Russ Suter
ID: 41734962
What's wrong with the one already provided? The SMO library will do exactly what you need. If you have a more specific question please feel free to ask.
0
 
LVL 1

Author Comment

by:CipherIS
ID: 41742497
I heard that there is a tool that will do that for you.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question