TFS VS2010 to SQL Server 2005: No Schema Compare option

  • Hi,

    I'm working on a contract and just imported some SQL Server 2005 databases in VS 2010 TFS. The Schemas imported just fine but curiously, when I try to do a schema compare, there is no option for that under the Data toolbar drop down or in the Schema Comparison right-click menu. The Data drop-down only has Transact-SQL Editor and Schema View as options. Am I stuck in some parallel mode that doesn't do schema compares?

    I'm pretty green on TFS so it's probably user error, just can't figure out what I'm missing. I can see all the object definitions for the databases I imported but no option to compare.

    Any ideas?

    Thanks!

  • Got it. They have VS2010 Professional which doesn't have the compare tool. Bummer.

  • Sounds to me like the latest version of SSDT isn't installed.

  • Tried that. It was a good idea but I don't get that option from the web installer--SSDT isn't in my pick list. Microsoft's on line documentation states that you have to have versions Premium or Ultimate to do schema compares. This company only has Professional.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply