I am using a program in Visual Studio 2010 which needs some SQL Databases and tables required to run the application. I have setup the Installer for this project using Visual Studio 2010 Deployment and Setup project. The project is creating the Setup.exe and Setup.msi file and I can install the application from fine.
The issue with this is, I can't install the SQL objects like Databases and Tables required for this application. I can't Do this manually. I want to use Visual Studio Packager to install this using Scripts. Please help me to get a solution.
I found a way that we can create "Custom Dialogs" for the installer and the installer will popup the dialog while setup going on. But I can't do this for SQL. Can you help me to create an SQL page for entering Servername, User, Password, etc.
Please help me on this regard.