SQL Data tools - Run post-deployment script with conditionals

Question

I'm working with a Database Projecto to deploy databases using "Data pack"

I've set up a paramenter "client", so depending the client I'll run a different set of scripts.

I tried different options, but nothing worked.

I've checked out Conditional logic in PostDeployment.sql script using SQLCMD but no luck

if '$(client)' = 'a' 
:r .\GeneralParams\s01.sql 
:r .\Clients\a\a01.sql 

GO

if '$(client)' = 'b'
:r .\GeneralParams\r01.sql
:r .\Clients\b\b01.sql

Inside every external scripts there are more than 1 GO When you see the output file to be executed, it´s compiling all external files into one.

Does anyone know a way to overcome this o a beautiful workaround

I tried this option:

if '$(client)' = 'a' 
:r .\GeneralParams\s01.sql 
if '$(client)' = 'a' 
:r .\Clients\a\a01.sql 

GO

if '$(client)' = 'b'
:r .\GeneralParams\r01.sql
if '$(client)' = 'b'
:r .\Clients\b\b01.sql

but r01 has more that 1 GO and exits the if clause

if the external file has only 1 GO the script works, but as I have multiple, the script execute some commands ignoring the IF clause — Juan Piaggio
– Juan Piaggio, Commented Aug 21, 2017 at 10:20
What worked for me, not as elegant as I wanted, is to put the if clauses on each external script — Juan Piaggio
– Juan Piaggio, Commented Aug 25, 2017 at 11:11

Juan Piaggio · Accepted Answer · 2018-09-20 09:51:29Z

0

the way I manage to implement this was doing individual if clauses inside each external file. It's not a pretty but it Worked. I've created an output clause to register all the crud changed made to the database.

answered Sep 20, 2018 at 9:51

Juan Piaggio

19012 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Data tools - Run post-deployment script with conditionals

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related