Team Foundation Server compare with specific version

GrahamGoodwin

Within SQL Compare it is possible to register a TFS folder(s) so that a 'get latest version' is performed prior to a comparison being carried out.

Is it also possible from within SQL Compare to get a specific labelled version (or even a changeset version) of the TFS files prior to a compare rather than simply the latest version?

It can be the case the we label a specific internal release version during database development and it would be useful to compare one internal release version against another so that a sync script could be produced.

Regards

Graham Goodwin

David Atkinson

You can't yet achieve this directly from our tools, although we do have upcoming plans to allow you to do this from within SSMS, as this ties in well with SQL Source Control.

In the meantime you can achieve this using Team Explorer or its command line. Simply 'get' the schema to a folder and point SQL Compare at this. It's not as integrated as it could be but will work well in the interim.

For example,
tf get /version:L"Your label"

There's more information here:

http://msdn.microsoft.com/en-us/library/zthc5x3f(VS.80).aspx

David