Compares and synchronizes SQL Server databases, backups and scripts.
Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong
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: 1
- Joined: Thu Jul 12, 2012 10:10 am
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.
- Posts: 6670
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Compare 10
Who is online
Users browsing this forum: No registered users and 0 guests