Hello! I’ve posted this in the Flexera Forums, but it doesn’t seem to want to appear there, so I figured I’d post this where I might be able to get some additional input, since this involves SQL Server Script Deployment in general.
What I attempted to post is this message below:
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.
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.
*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.