Activity overview
Latest activity by AlexMBanks
RichardL said:
Hi @AlexMBanks Thanks for your post. If you have a support contract and would like a support engineer to investigate your issue then please send
us a ticket Kind regards Richard Lynch.
Thanks for the suggestion, @RichardL. I found the answer to my issue in a different discussion here: https://forum.red-gate.com/discussion/comment/152306#Comment_152306 / comments
RichardL said:
Hi @AlexMBanks Thanks for your post. If you have a support contract and would like a support engineer to investigate your issue then please send
us a ticket Kind regardsRichard...
bluebird84 said:
Brian Donahue wrote:
Sorry, just realized this is v7 and I am using v10. Is it possible for you to upgrade?
I downloaded the trial version of v10 and I have exactly the same issue as in V7 when using the same project file. I then created a new project and didn't have the issue. I compared the Options and the Include Identity Column option wasn't checked. Once that was checked in v7 and v10 it mapped correctly.
thanks
Thanks bluebird84, this was driving me crazy. I was dreading having to manually go through and set several hundred comparison keys - your suggestion to use the 'Include Identity Column' option fixed the issue for me. What I still don't understand is why it was treating my two databases differently in the first place - they were literally deployed from the same source. / comments
bluebird84 said:
Brian Donahue wrote:
Sorry, just realized this is v7 and I am using v10. Is it possible for you to upgrade?
I downloaded the trial version of v10 and I have exactly the ...
I have this issue as well - it makes Data Compare annoying at best and unusable at worst. Comparing two identical databases (built from the same source!) and I get a host of issues. It often doesn't use the PK for the comparison by default (it doesn't say why) or I have to manually add the individual columns for each table. Even then, for some columns it will sometimes say 'the column data types prevent this mapping being used as part of custom comparison key', despite the fact that a) the same column for the comparison database is accepted without issue b) SQL Compare registers the tables as identical. The screenshot below shows this issue. [image] When the applications maps things correctly it's invaluable, but I often dread having to use it because of this. I'm hoping this is just me missing some config option or doing something wrong. / comments
I have this issue as well - it makes Data Compare annoying at best and unusable at worst. Comparing two identical databases (built from the same source!) and I get a host of issues. It often doesn'...
Hi RichardL Yes, I'm afraid we're still having this issue. We've worked around it a couple of times but I can't recall exactly what we did - I think we had to update to a particular revision, then update from there to HEAD. I'll try to duplicate the workaround and get in touch with the support team. We're looking to move to ReadyRoll soon anyway, but obviously we need to get our build stable first. Regards, Alex / comments
Hi RichardLYes, I'm afraid we're still having this issue. We've worked around it a couple of times but I can't recall exactly what we did - I think we had to update to a particular revision, then u...
I am having exactly the same issue with LocalDb on SQL Source Control 6. Has there been any progress on a solution, or even a workaround? / comments
I am having exactly the same issue with LocalDb on SQL Source Control 6. Has there been any progress on a solution, or even a workaround?
I'm still having this problem in 2018, on version 6.0.2.6908. No triggers involved, but getting the same duplicate error for an index instead.
There is no duplicate definition in the source code and we can commit and update an empty database with no issues. So when we rebuild the database from scratch (i.e. no data), it works. If there's data in the table then it fails.
For whatever reason, the CREATE INDEX code appears in one of the automatically generated AutomaticSchemaChange.patch files. I don't know if this is what is being picked up by SQL Compare. / comments
I'm still having this problem in 2018, on version 6.0.2.6908. No triggers involved, but getting the same duplicate error for an index instead.
There is no duplicate definition in the source code an...
We are having the same issue described here - lockouts on AD accounts. I'd just like to add that we are only seeing this issue when connecting with accounts from different domains. e.g. when using 'run as different user'. I have not tried the <defaultProxy> config change yet. / comments
We are having the same issue described here - lockouts on AD accounts. I'd just like to add that we are only seeing this issue when connecting with accounts from different domains. e.g. when using ...
Thanks for the response, Robert. This might help point us in the right direction. / comments
Thanks for the response, Robert. This might help point us in the right direction.
Generating a set of related rows
Some of our business data is logically grouped into sets and I can't find any way to generate data in this format with SDG. The sets are composed of a series of values with numeric indices and we r...