Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

TFS VS2010 to SQL Server 2005: No Schema Compare option Expand / Collapse
Author
Message
Posted Monday, March 17, 2014 3:07 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 19, 2014 12:18 PM
Points: 62, Visits: 167
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!
Post #1551926
Posted Monday, March 17, 2014 3:39 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 19, 2014 12:18 PM
Points: 62, Visits: 167
Got it. They have VS2010 Professional which doesn't have the compare tool. Bummer.
Post #1551943
Posted Tuesday, March 18, 2014 6:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, July 20, 2014 4:32 PM
Points: 14, Visits: 50
Sounds to me like the latest version of SSDT isn't installed.
Post #1552126
Posted Tuesday, March 18, 2014 9:36 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 19, 2014 12:18 PM
Points: 62, Visits: 167
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.
Post #1552263
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse