?
Solved

C# Install and Make Database Changes

Posted on 2016-07-26
4
Medium Priority
?
71 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
  • 2
  • 2
4 Comments
 
LVL 20

Accepted Solution

by:
Russ Suter earned 2000 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

SingleRun is a tool that ensures that only one instance of an application is started, running it again brings the application to focus.
An ASP.NET Web Form User Control is not newly introduced in ASP.NET. In fact, it was an old technology yet still playing a role to generate web content, especially when we want to use it to have a better and easy way to control part of the web conte…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

601 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