This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Arshbeer_Singh
Level 5
‎Apr 29, 2015 09:43 AM

Multiple Database scripts in Basic MSI Project

Hi

I am creating a Basic MSI project and in the the Sql Scripts part i want to create scripts for multiple databases. is there a way to achieve it?
Currently it is showing just 4 options namely Azure,Sql Server, MySQL and Oracle.
Any approach or any sort of help to achieve this task is appreciated.:(
Labels (1)
Labels
0 Kudos
(3) Replies
rguggisberg
Level 13
‎Apr 29, 2015 09:58 AM

Yes. I am doing that for InstallScript MSI projects. Go to Scripts view under Server Configuration.
Right Click on SQL Scripts and choose 'New SQL Connection'. Under that add scripts for that connection.
Repeat the above for each database (SQL Connection) as needed.
0 Kudos
Arshbeer_Singh
Level 5
‎Apr 29, 2015 11:13 PM

I got your point . But will it work for a cybase connection as after clicking a new connection the database to target in requirements tab are just Windows Azure,SQL Server, MySQL and Oracle. Wont that have an effect?
0 Kudos
Christopher_Pai
Level 16
‎Apr 30, 2015 02:04 AM

I've never heard of cybase. You'll need to write custom actions if you want to connect to a Sybase RDBMS.
0 Kudos