Activity overview
Latest activity by PaulOckenden
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.
Crash if deploying too many tables
I have several thousand tables. Using SQL Compare (and then data compare) to move the data to a new database.
If I select more than approx 500 tables at a time I've noticed that SQL Compare just cr...
Not matching identity columns as comparison key
Where tables have no IX or PK, I'd assumed that SDC would pick an identity column (if one exists) to match on. Especially if the "include identity columns" option is ticked.
But it seems this isn't...
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.
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...
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.
Owner mapping - one to many
I'm trying to investigate whether SQL Compare will work for us.
Database A has loads of tables, half owned by [dbo] and half by [userA]. Database B is a mirror, but all of the tables are owned by [...