Having Fun with VS Setup Project - Database Deployment

I was given a new task, to create an installer for internal use. I wrote installer before, but it was three years ago, a lot of things have changed.

One of the installer task is to create a sql server db using a script. After much reading, searching, and testing, I got into this msdn article. https://msdn2.microsoft.com/en-us/library/49b92ztk.aspx.

The article was good enough to get me started, the only thing is, the source code was in VB instead of C#. If you decided to follow that example above using C#, there is a chance that you may asked yourself about C# equivalent of VB's My.Settings. Don't worry too much, it just a strong-typed application setting. Just use ConfigurationManager, if you are more comfortable with it.

If you have done database deployment using msi in the past, I will appreciate some feedback or information.

Stay tuned, I am planning to add more stuff that I learned from building setup project using VS 2005.