How to add PostDeploy script during Schema Compare generate script

Question

I am comparing the current version of my Database Project with a dacpac (previous version of the same database).

Then i hit the generate script button what gives me, as expected, the change script.

Unfortunately i does not add the Post deployment script to the change script.

If i use the "Publish Database" feature and compare against a "real" db it creates a update script with the post deploy script but i require this feature in the schema compare.

Is there any option i overlooked?

How did you solved the problem?

Peter Schott · Accepted Answer · 2013-09-05 21:56:23Z

5

You need to actually publish the project to use the Post-Deploy and Pre-Deploy scripts. The Post-Deploy script is not part of the SQL Compare. The SQL Compare option only compares actual database options. I'd recommend using the Publish command, setting your options the way you want, then saving that as part of the project. You can easily use that to generate a script. You'll need to compare against a real database anyway in order to do a schema comparison, so this should be very similar to the option you're already using.

answered Sep 5, 2013 at 21:56

Peter Schott

4,73625 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to add PostDeploy script during Schema Compare generate script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related