What are the challenges you face when working across database platforms? Take the survey
Options

Is it possible to run post-deployment script without a schema change?

We have recently started using pre- and post deployment scripts in our development process.
For updating our development databases we are using the Sync-DatabaseSchema cmdlet.
Is ist possible to force this cmdlet to always perform the pre- and post-deployment scripts - even if there are no schema changes?

Answers

  • Options
    Hi david_k,

    Thanks for posting on the Redgate forums.

    No, there isn't a way to do this. The workaround to achieve this would be to either run this manually or do a meaningless change to force the release to run.

    For example create a stored procedure:

    create procedure GetOne as select 1

    The next time you need the script to run and you have no changes dropping this procedure will get this run for you.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
Sign In or Register to comment.