This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- SQL Server 2008 Install Script Project (How to)
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 04, 2008
02:19 PM
SQL Server 2008 Install Script Project (How to)
Any one have any luck with this. I have found nothing on how to do this and looks like I am going to have to 'roll my own' again ?:eek:
(4) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 04, 2008
02:50 PM
What are you trying to do?
Install your product database in SQL 2008?
Modify the database in SQL 2008?
Install SQL Server 2008 express edition?
Install your product database in SQL 2008?
Modify the database in SQL 2008?
Install SQL Server 2008 express edition?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 05, 2008
07:53 AM
I would say divide and conquer,,,,
First install SQL2008 Express via the install script.
I probably can figure out how to install our db once that is done.
Down the road accept ugrades etc.
First install SQL2008 Express via the install script.
I probably can figure out how to install our db once that is done.
Down the road accept ugrades etc.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 05, 2008
09:25 AM
I would highly recommend that you leave the SQL Server 2008 Express installation within the Microsoft installation. You see, if you use it in a module, it doesn't show up in Add/Remove programs. Furthermore, if there is a patch, then you are responsible for creating the patch. We put the installation onto our CD and use command line parameters to install SQL Server.
As for installing the Database when it is installed, I created a set of ADO objects within Install Shield script that connects to the database and run a set of SQL statements. Now, Install Shield (IS) already contains the ability to run SQL versus SQL Server Database. I run it by hand for other reasons. If you like to know what they are, let me know. In the meantime, here is a link that shows a brief example on how to use ADO objects in install shield script.
Hope this helps.
As for installing the Database when it is installed, I created a set of ADO objects within Install Shield script that connects to the database and run a set of SQL statements. Now, Install Shield (IS) already contains the ability to run SQL versus SQL Server Database. I run it by hand for other reasons. If you like to know what they are, let me know. In the meantime, here is a link that shows a brief example on how to use ADO objects in install shield script.
Hope this helps.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 05, 2008
09:43 AM
Here is another link that might interest you. You are not alone in what you were trying to do.
Hope this helps.
Hope this helps.