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.
AdminRedgate Administrator
(Admin, Redgate)
shared this idea
SQL Source Control will now let you compare two revisions in the History dialog through SQL Compare
-
AdminJames Billings
(Admin, Redgate)
commented
Version 3.6.7.246 (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?
-
Chad.Hattabaugh
commented
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.