Options

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

david_kdavid_k Posts: 2 Bronze 1
in SQL Change Automation
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?
Tagged:
· Share on Twitter

Answers

  • Options
    Dan BDan B Posts: 287 Gold 5
    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
    · Share on Twitter
Sign In or Register to comment.