sql-servervisual-studio-2010version-controlsqlcompare

Red Gate SQL Compare vs. VS2010 Ultimate

I used to use SQL2000 and Red Gate SQL Compare 3.2 and I was a happy camper. I wouldn't worry about tracking the changes that I make to the dev database until all the coding was done and I needed to compile a list of scripts to bring the prod db in sync with the prod.

This is where SQL Compare and to some degree, SQL Data Compare, were invaluable in

  1. pointing out the differences and even more importantly,
  2. helping me generate the SQLs to bring the prod db in sync with the dev db.

I see that VS2010 Ultimate allows me to compare two schemas, but does do #2? I believe it is suppose to but it ain't obvious to me how to do that.

Any kick in the right direction would be an immediate vote up or better. ty.

Solution

  • Yes, it does (2). To achieve this, run the comparison (Data/Schema Compare/New Schema Comparison), choose the objects you want to update, and then right click on the grid or go to the Data/Schema Compare menu and select Refresh Update script. If you can't see an upgrade script now, select Show Schema Update Script which is in the same menu.

    If you want a more user-friendly and versatile tool, please consider trying SQL Compare 8! (I'm the product manager)