Posts
Sort by recent activity
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...
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 [...