Red Gate forums :: View topic - Set compare source to existing TFS project
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Set compare source to existing TFS project

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
foneill



Joined: 12 Jul 2012
Posts: 1

PostPosted: Thu Jul 12, 2012 10:28 am    Post subject: Set compare source to existing TFS project Reply with quote

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?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Mon Jul 16, 2012 4:04 pm    Post subject: Reply with quote

Hello,

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.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1114
Location: Twitter: @dtabase

PostPosted: Thu Sep 20, 2012 3:13 pm    Post subject: Reply with quote

Hi,

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

http://www.red-gate.com/EAP/SQLCompareEAP/SQLCompareVS

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

Kind regards,

David Atkinson
Product Manager
Red Gate
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group