SQL Server project executing multiple script post deploy

sql sql-server visual-studio sql-server-2008 database-project
Paul Michaels picture Paul Michaels · Apr 17, 2014 · Viewed 11.5k times · Source

I have a SQL Server 2008 DB Project, and want to execute multiple scripts, in order, on post deploy.

I've added a PostDeploy.Sql script to a scripts folder, and marked that as PostDeploy, and that works fine. I'm aware that only one script can be marked as post deploy; so I thought I could do this within the script:

-- Post Deploy stuff
SELECT * FROM MYTABLE
GO

:r RunPostDeploy2.sql
GO

Where RunPostDeploy2.sql is located within the same directory as a link. I've tried copying the file locally, but the issue seems to be the use of :r.

Is it possible to call external scripts from post deploy in this way and, if so, how?

Answer

ravish.hacker picture ravish.hacker · Mar 16, 2016

You have to turn your script into SQLCMD mode. There is a toolbar button right on the top of the file like this.

enter image description here

Or you can do this by going to

enter image description here

Related questions

#region functionality in SSMS 2008

Using Sql Server 2008, is there any functionality similar to #region in Visual Studio? I'm aware that nodes appear to allow collapsing of SQL segments, but as far as I know, this is based on the syntax of the SQL statement. …

Read More
Warning SQL71502 - Procedure <name> has an unresolved reference to object <name>

I'm getting the following warning in my Visual Studio 2013 project: SQL71502 - Procedure has an unresolved reference to object

Read More
Do I need a database reference for a linked server in a SQL Server database project?

In my database project, I have added a reference to a linked server. When I use this linked server in a view and try to build my database project, SSDT reports errors because it cannot understand references to any of …

Read More