September 16, 2009 at 9:46 am
Dear all, there is a case that I needed to compare the records of tables (with more than 150million rows) in two schema-identical databases on different servers, but with several constraints, for example,
1. CPU consumption should not be high,
2. tempdb size on both servers are limited,
3. there are tables without primary key, index, unique things
4. both databases could not be exported
5. both databases are read-only
6. no system-wide configuration could be made on the servers, eg., linked db, etc
There is no constraint on the completion time of comparison.
Do you have any idea for this? Thanks
September 16, 2009 at 9:49 am
Sorry for missing one point, I am using SQL Server 2005 enterprise (x86). Thx.
September 16, 2009 at 10:00 am
yves-386841 (9/16/2009)
3. there are tables without primary key, index, unique things
Without primary keys or any unique identifiers then what are you going to use to compare rows?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply