CODEWITHSUNDEEP
visual-studio-2013msbuildinstallshieldsql-server-data-tools
Rob G
Rob G

Reputation: 121

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

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.

Upvotes: 0

Views: 485

Answers (1)

Ed Elliott
Ed Elliott

Reputation: 6856

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

Upvotes: 0

Related Questions