Generate SQL Scripts from SSDT project (VS2013 / TFS2012 [MSBuild]) for use in InstallShield 2013 Pro

0
votes

We are using Visual Studio 2013 with SQL Server Data Tools (SSDT) to develop our database projects. When TFS builds the database project, the "_Create.sql" file generated requires SQLCMD mode and contains variables. InstallShield 2013 does not appear to support SQLCMD mode (investigation points to InstallShield using ODBC and/or OLEDB drivers to execute SQL scripts).

Essentially, I need our TFS build process to create a "standard" SQL script, compatible with InstallShield 2013 Professional. Has anybody had any experience with this... and if so, please can you provide some pointers?

Thanks.

1
visual-studio-2013msbuildinstallshieldsql-server-data-tools

1 Answers

0
votes

Can you not just create a step in installshield to either call sqlcmd.exe or even better sqlpackage.exe and pass in the dacpac?