How can we help you today? How can we help you today?

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?
David
0

Comments

1 comment

Sort by
  • Dan B
    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.
    Dan B
    0

Add comment

Please sign in to leave a comment.