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

david_k

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?

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.