Comments
Sort by recent activity
No crash report - the application just quits. Memory usage was quite high (10-15Gb), but I often see much higher usage with Data Compare, so I don't think that's it. / comments
No crash report - the application just quits. Memory usage was quite high (10-15Gb), but I often see much higher usage with Data Compare, so I don't think that's it.
Well, I guess that in this instance although you could have two source tables named the same with different schemas, you'd only have one in the target database (because you only have a single schema).
So for the tables on the left hand side one would match and one would fail during comparison.
I wonder whether another way to tackle this would be to have an 'ignore schema' in the options? But with a note saying that option can only be used when table names are unique between schemas. perhaps that might be easier from a UI point of view, and also easier for people to understand.
P. / comments
Well, I guess that in this instance although you could have two source tables named the same with different schemas, you'd only have one in the target database (because you only have a single schem...
That's great - thanks Sam.
I always work on the theory that if one customer (or potential customer) asks for something, there will usually be a load more that are too shy to ask!
P. / comments
That's great - thanks Sam.
I always work on the theory that if one customer (or potential customer) asks for something, there will usually be a load more that are too shy to ask!
P.
In the bit at the bottom (unmapped stuff) you can currently select just one item from the left and one from the right and hit the map button.
I think it should allow you to select more than one owner from the source database.
e.g.
[dbo] |
[UserA] |
| [dbo]
I should be able to select all three rows, and hit map.
This would then create TWO mappings in the table above:
[dbo] -> [dbo]
[UserA] -> [dbo]
Does that make sense?
(The other option would be to go in and tinker with the saved project definition files prior to deployment - then you wouldn't have to build a UI, but not sure whether this is feasible.)
Thanks,
P. / comments
In the bit at the bottom (unmapped stuff) you can currently select just one item from the left and one from the right and hit the map button.
I think it should allow you to select more than one own...
There are literally THOUSANDS of tables!
I don't understand why I can't do it in owner mapping. / comments
There are literally THOUSANDS of tables!
I don't understand why I can't do it in owner mapping.