Diff or compare versions of an object
I want to be able to diff/compare my db object to the previous version so I can see exactly what I changed. This would allow me to view differences between my current version and the previous version. I also want to be able to select which version I diff/compare the object to so I could see changes between any 2 versions.
SQL Source Control will now let you compare two revisions in the History dialog through SQL Compare
AdminJames Billings (Admin, Redgate) commented
Version 220.127.116.11 (at the time of writing on our "frequent updates" channel now lets you select two revisions in the History screen and launch SQL Compare / SQL Data Compare to compare them.
For information on Frequent Updates, see here: http://documentation.red-gate.com/display/SOC3/Turning+on+frequent+updates
If you have SQL Compare Pro, you could checkout/get the 2 versions you want to compare to a folder for each. Then, you could use SQL Compare Pro's "scripts folder" feature to compare these 2 versions and generate a synch script.
We hope to make this more integrated in a future version.
Has anyone tried this yet?
It would be nice to compare a single object in the database to a version in source control (maybe via a right click on the object.) It would also be nice to be able to select the version I compare to.
paul price commented
The SQL Compare tool shows you the differences between two databases nicely, so the interface already exists. So I would expect this to be rather trivial to add to Source Control.