PDA

View Full Version : Using InstallShield to deploy SQL Server Scripts



Nickolaus
08-01-2017, 11:52 AM
Hello! I'm still pretty new to InstallShield, so I have no idea how strange this request is. My previous experience with this has been to install a WPF application, using the InstallShield integrated with Visual Studio.

I've been asked to use InstallShield to deploy SQL Scripts to the database, and while there is a web application involved, that project seems to have its own separate installer.

I've created a test project to try this out, I'm just not sure if I'm going about this the right way. I've been following a couple of guides to help me to figure this out.

Links:
http://helpnet.installshield.com/installshield22helplib/helplibrary/SQLServer.htm
http://helpnet.installshield.com/installshield21helplib/helplibrary/SQL-CreatingSampProjSQLServer.htm

What I've done so far:

Using the InstallShield application, (not using Visual Studio) I created a Basic MSI Project. In the Installation Designer, I went to Server Configuration, then clicked on SQL Scripts. I added a new Connection, and then underneath that connection, I imported all of the SQL Scripts from the database project.

Things I have not done:

Run the database import wizard for the database these scripts are to be run against.

Questions:
I've noticed that creating this project will create a folder in the Program Files directory. I can't seem to find a way to disable that, is there a way to do so?
As far as I know, the reason I've been asked to do this is so that the person Installing these scripts can just run this installer, select the database, and then the scripts will just install into the database automatically, simplifying the installation. Is there anything else I need to do to make sure this is possible?
Am I using the right InstallShield project type to do this?
Is InstallShield not really meant for this kind of usage, should I be using a different tool/script (e.g. Powershell maybe?) for this kind of task?

Any guidance is appreciated, InstallShield and creating installers is really new to me.