Create a snapshot of target database before deployment
I usually create a snapshot of the target database before each deployment so I can compare again later to see the changes or generate a reversal script on selected objects. Please add the option to the Deployment wizard alongside "Back up target before deployment"
3
votes
![](https://secure.gravatar.com/avatar/874a0c93f772fb4b886522cd71e5252d?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
@tdennis - sorry for the late reply. This option already exists. If you select "Backup of target" in the Deployment Wizard, the first radio button is "Create a SQL Compare snapshot".