C# Install and Make Database Changes

CipherIS
CipherIS used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial