TFS VS2010 to SQL Server 2005: No Schema Compare option

• Fly Girl

  SSCommitted

  Points: 1560

  More actions

  March 17, 2014 at 3:07 pm

  #284741

  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!

• Fly Girl

  SSCommitted

  Points: 1560

  More actions

  March 17, 2014 at 3:39 pm

  #1697807

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

• drew.king1

  Old Hand

  Points: 336

  More actions

  March 18, 2014 at 6:21 am

  #1697957

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

• Fly Girl

  SSCommitted

  Points: 1560

  More actions

  March 18, 2014 at 9:36 am

  #1698081

  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.