Improve company productivity with a Business Account.Sign Up

x
?
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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Article by: Shaun
Tiling windows is a great way to see multiple applications at once. Windows Tiler is a tool that automatically tiles open application windows as the open and close.
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…
Watch the working video to know how to import Outlook PST/OST files to Amazon WorkMail. Kernel released this tool which is very easy to use and migrate single or multiple PST and OST files to Amazon WorkMail. To know more about Kernel Import PST to …

589 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