Set compare source to existing TFS project

Forum for users of SQL Compare schema synchronization utility

Set compare source to existing TFS project

Postby foneill » Thu Jul 12, 2012 9:28 am

I wonder if I'm attempting the impossible...

I have an Azure solution in TFS, and the databases are also under source control there (as Database Projects). I want to use this TFS project as the source for my SQL Compare. When I attempt to use that, SQL Compare tells me "Unable to find a RedGate.ssc file at the database location specified".

It seems that I need to use Red Gate's "SQL Source Control" to create his file, but I don't want to do that - the database is already successfully under source control, and I don't want to add it a second time.

So, is there some way that SQL Compare can look at pre-existing TFS database details?
Posts: 2
Joined: Thu Jul 12, 2012 9:10 am

Postby Brian Donahue » Mon Jul 16, 2012 3:04 pm


I think it should work to export all of the .sql files from TFS into a folder and tell SQL Compare to compare to source control, but then specify a scripts folder rather than a repository.

I'd like to add a warning that if the scripts were not created by SQL Compare (for instance, they were created by SSMS or "by hand"), SQL Compare may have trouble reading the files and/or ordering the objects correctly.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Postby David Atkinson » Thu Sep 20, 2012 2:13 pm


We have a beta build that now works with VS database projects:

Please try this out and let us know how you get on. Feedback very welcome!

Kind regards,

David Atkinson
Product Manager
Red Gate
David Atkinson
Posts: 1143
Joined: Mon Dec 05, 2005 3:54 pm
Location: Twitter: @dtabase

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest