how to use RedGate SQL Compare 11 to compare the difference between two database
- open the app and go through the wizard picking the two databases to compare
- you will get a comparison summary wherein you should click the checkboxes for all of the items which appear
- click the "Deployment Wizard..." button at the top nav
- at the "Deployment" pane which appears, keep the "Create a deployment script" option
- finish up the wizard... next, next, next
- you will end up with a SQL script that will do what it needs to to reshape the second database to be like the first and by default it should open up in SSMS
No comments:
Post a Comment