Activity overview
Latest activity by Andy C S
Hi Damian,
I see you previously had a ticket open with my colleague Evan about a similar problem last year - has this issue been ongoing since then, or has it just started cropping up again recently?
Ideally, to properly troubleshoot this we'd need a copy of the latest revision of your repository and a backup or SQL Compare snapshot of your database - if you feel comfortable providing that, could you email it to support@red-gate.com and quote ticket number #22352? If you need, we can set up an FTP area for large files. Thanks for your help with this! / comments
Hi Damian,
I see you previously had a ticket open with my colleague Evan about a similar problem last year - has this issue been ongoing since then, or has it just started cropping up again recentl...
Glad to hear you're back up and running! Let us know if you have any other problems and we'll do our best to help out. / comments
Glad to hear you're back up and running! Let us know if you have any other problems and we'll do our best to help out.
Hi,
What exactly do you mean by "in the case that a compare isn't automatically detected"? Is SQL Data Compare mapping the tables correctly, but leaving out certain columns, or is it failing to map the tables at all? / comments
Hi,
What exactly do you mean by "in the case that a compare isn't automatically detected"? Is SQL Data Compare mapping the tables correctly, but leaving out certain columns, or is it failing to map...
Well, something's definitely gone wrong creating that project file - there's no fewer than 5 separate WHERE clauses specified for the table [dbo].[TradeReviewReason], and it looks like SQL Data Compare is just using the first it runs into.
I'm afraid I'm having trouble reproducing this, though - whenever I edit a WHERE clause in a project file SQL Data Compare behaves as I'd expect it to, which is to say it removes the old WHERE clause, adds the new one, and if the new one is invalid throws an error on comparison. Can you run through the exact steps you took in changing that WHERE clause? / comments
Well, something's definitely gone wrong creating that project file - there's no fewer than 5 separate WHERE clauses specified for the table [dbo].[TradeReviewReason], and it looks like SQL Data Com...
Hi Scott,
That's really odd - if you could send us the .sdc file that'd be great so we can try and reproduce what's going on here. Can you send that to support@red-gate.com and quote the ticket number #21166? Thanks for your help with this! / comments
Hi Scott,
That's really odd - if you could send us the .sdc file that'd be great so we can try and reproduce what's going on here. Can you send that to support@red-gate.com and quote the ticket num...
I'm not 100% sure of some of the terminology you're using here, but unlinking and relinking a database should clear out the local files SQL Source Control keeps. Any differences between your database and your repository should show up as conflicts after a relink. Can you try unlinking, restarting SSMS and then relinking and let me know if that works any better? / comments
I'm not 100% sure of some of the terminology you're using here, but unlinking and relinking a database should clear out the local files SQL Source Control keeps. Any differences between your databa...
Peter:
We've actually had a few reports since the most recent ESET false positive - can you double check that ESET hasn't automatically set up some rules do nuke any Red Gate DLLs? As I recall, that was once a problem before.
altoredgate:
Are there any specific questions you've got that I can help you with? It might be worth starting your own thread if you're not getting the specific "Add-in failed to load" error message, but we'll be happy to help out all the same - alternatively, you can email support@red-gate.com. / comments
Peter:
We've actually had a few reports since the most recent ESET false positive - can you double check that ESET hasn't automatically set up some rules do nuke any Red Gate DLLs? As I recall, tha...
Hi Mickeal,
That ought to work - can you send a screenshot to support@red-gate.com and include the ticket reference number #19866? / comments
Hi Mickeal,
That ought to work - can you send a screenshot to support@red-gate.com and include the ticket reference number #19866?
Hi Michael,
It looks like this is caused by the way SQL Compare scripts out the changes - if you have a look at the deployment script, you'll see that it attempts to drop the role first, which is what causes the problem. You can work around it in one of two ways:
1. Run two separate deployments with SQL Compare, first dropping the user and then the role
2. Get SQL Compare to generate a deployment script and manually edit it to drop the user before the role
I suspect there's an underlying reason that we don't correctly deal with user dependencies like this, but I'm chasing up the SQL Compare team to see if there's a way we can deal with it better. Hope that helps! / comments
Hi Michael,
It looks like this is caused by the way SQL Compare scripts out the changes - if you have a look at the deployment script, you'll see that it attempts to drop the role first, which is w...
Hi Peter,
Stuff like this is often very hard to troubleshoot, because we get very little information about what specifically is going wrong - all we can tell is that SSMS is failing to find some file, but if SQL Source Control didn't throw an error during install we'd expect all of the correct files to be in the right place.
It sounds like you've already tried almost all of the things we'd recommend - the only other thing I can offer that other users have said has helped in the past is uninstalling SQL Source Control, performing a repair installation on SQL Server and reinstalling the product. Do you have other SSMS plugins installed, like SQL Prompt? Do they have the same issue? / comments
Hi Peter,
Stuff like this is often very hard to troubleshoot, because we get very little information about what specifically is going wrong - all we can tell is that SSMS is failing to find some fi...