May 16, 2019 at 8:39 am
Hi,
How execute SELECT query in Sql server dacpack Post-Deployment Script.
Is it possible conditional statement (IF statement) in Post-Deployment Script ?
Thanks in advance
Regards
Binu
May 19, 2019 at 5:10 am
hi,
anybody can help...
Regards
binu
May 30, 2019 at 1:26 pm
hi,
anybody can help
Regards
binu
June 3, 2019 at 2:05 pm
Can you explain what it is you are trying to do?
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 3, 2019 at 8:57 pm
i think you need to execute a script after the dacpac deployment.
a dacpac will create tables and objects, but there's no scripting involved, so no, no script can be appended to the dacpac.
a script can contain all the logic you desire, and that's where you might have conditional scripts based on s ervername, environment, time or anything else you want to test for, and use logic to execute.
Lowell
June 3, 2019 at 9:10 pm
I cannot see how executing a SELECT query in a post-deployment script will achieve anything useful. Where are you expecting the SELECTed data to go?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 3, 2019 at 9:16 pm
i think you need to execute a script after the dacpac deployment. a dacpac will create tables and objects, but there's no scripting involved, so no, no script can be appended to the dacpac. a script can contain all the logic you desire, and that's where you might have conditional scripts based on s ervername, environment, time or anything else you want to test for, and use logic to execute.
This is not necessarily correct. If you develop your database in SSDT, adding a post-deployment script is a straightforward task. When this database is Published, a DACPAC is created which contains the post-deployment script. The PD script is executed as part of the Publish action.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply