Installers with Database project

[Varangian]

Hi,

I have a database project and along with its scripts and stored
procedures I want to add them to the installer file (web installer
project). However sadly the database project is not listed as project
output when you try to add it. Nothing not even its contents......

what I wish is that I can add the Database project output.. so that
any changes or new sql scripts will be added or packaged every time
automatically and reflecting the changes.
any ideas?

This is something missing in the .NET framework.

Thanks!

 

[oscar.acostamontesde]

Hi,

I have a database project and along with its scripts and stored
procedures I want to add them to the installer file (web installer
project). However sadly the database project is not listed as project
output when you try to add it. Nothing not even its contents......

what I wish is that I can add the Database project output.. so that
any changes or new sql scripts will be added or packaged every time
automatically and reflecting the changes.
any ideas?

This is something missing in the .NET framework.

Thanks!

Well, when I had that problem, i soved it by creating a custom action
(Inheriting from Installer class), embeding the sql scripts in this
assembly and executing them using isql in OnBeforeInstall event.
Hope this help, best regards.
Oscar Acosta