We help IT Professionals succeed at work.

C# Install and Make Database Changes

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
Comment
Watch Question

Senior Software Developer
Commented:
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.

Author

Commented:
Any other suggestions?
Russ SuterSenior Software Developer

Commented:
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.

Author

Commented:
I heard that there is a tool that will do that for you.