This project has moved and is read-only. For the latest updates, please go here.

to include SQL files in MSI

Topics: Bindings File, Settings Management and SSO, General Questions, Getting Started/Beginner
Dec 3, 2010 at 8:50 AM


I ahve a biztalk project and I need to include  SQL scripts file to my MSI .


How can i do this by using BTDF?


THanks ,


Dec 3, 2010 at 3:06 PM

Just add the script file(s) to an AdditionalFiles ItemGroup, which will cause them to be included in the MSI.  To run the script you can use a target in your .btdfproj called CustomDeployTarget and an Exec task to call osql.exe or sqlcmd.exe from SQL Server to run the script.