Thursday, June 25, 2015

how to use RedGate SQL Compare 11 to compare the difference between two database

  1. open the app and go through the wizard picking the two databases to compare
  2. you will get a comparison summary wherein you should click the checkboxes for all of the items which appear
  3. click the "Deployment Wizard..." button at the top nav
  4. at the "Deployment" pane which appears, keep the "Create a deployment script" option
  5. finish up the wizard... next, next, next
  6. 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