Post reply

How execute SELECT query in Sql server Post-Deployment Script

  • May 16, 2019 at 8:39 am

    #3644120

    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

    #3645089

    hi,

     

    anybody can help...

     

    Regards

    binu

  • May 30, 2019 at 1:26 pm

    #3648575

    hi,

     

    anybody can help

     

    Regards

    binu

  • June 3, 2019 at 2:05 pm

    #3649742

    Can you explain what it is you are trying to do?

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • June 3, 2019 at 8:57 pm

    #3649923

    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

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 3, 2019 at 9:10 pm

    #3649927

    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?

  • June 3, 2019 at 9:16 pm

    #3649928

    Lowell wrote:

    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.

    • This reply was modified 5 years, 10 months ago by  Phil Parkin.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy