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 Service Broker Install
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
Jul 20, 2010
07:44 AM
SQL Service Broker Install
I am authoring a set of InstallScript based installers for installing and configuring Service Broker for SQL Server.
One of the remaining Items I need to figure out how to do is to run query on a SQL Instance after a SQL Install Script has run, and get the results back into InstallScipt so that I can modify a set of SQL Scripts.
Here are the steps to complete:
1). Install Service Broker on SQL Instance One (Using an Install SQL Script)
2). Query the GUID from Service Broker on Instance One
3). Install Service Broker on SQL Instance Two
4). Query the GUID from the Service Broker on Instance Two
5). Create a Route on SQL Instance One with GUID from SQL Instance Two
6). Create a Route on SQL Instance Two with a GUID from SQL Instance One
Is there native support in InstallScript for getting the results of a SQL Query back into InstallScript?
One of the remaining Items I need to figure out how to do is to run query on a SQL Instance after a SQL Install Script has run, and get the results back into InstallScipt so that I can modify a set of SQL Scripts.
Here are the steps to complete:
1). Install Service Broker on SQL Instance One (Using an Install SQL Script)
2). Query the GUID from Service Broker on Instance One
3). Install Service Broker on SQL Instance Two
4). Query the GUID from the Service Broker on Instance Two
5). Create a Route on SQL Instance One with GUID from SQL Instance Two
6). Create a Route on SQL Instance Two with a GUID from SQL Instance One
Is there native support in InstallScript for getting the results of a SQL Query back into InstallScript?
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Jul 21, 2010
09:00 AM
Unfortunately, the built-in SQL Scripts functionality does not has the ability that allows you to handle SQL query results outside SQL scripts. In order to accomplish your requirements, you need to write your own code that will manage database connections and run your SQL scripts. There are several sample codes posted in this community forum:
http://community.flexerasoftware.com/showpost.php?p=288448&postcount=17
http://community.flexerasoftware.com/showpost.php?p=266290&postcount=2
Hope that helps.
http://community.flexerasoftware.com/showpost.php?p=288448&postcount=17
http://community.flexerasoftware.com/showpost.php?p=266290&postcount=2
Hope that helps.
![](/skins/images/CC38E504FC9E1309DC48ACFEB4925670/responsive_peak/images/icon_anonymous_message.png)