G
Guest
Hello Gurus,
I'm looking for a tool or technique that will compare the data in two MDB
databases. The ideal result would be a report that shows:
1. A list of all tables in each MDB
2. Record count for each table in each MDB
3. Table Delta: tables that exist in one MDB and not the other
4. Field Delta: fields that exist in only one MDB (where the table is in both)
5. Data Delta: data that is not the same in both MDBs
The tool would link tables with the same name in both MDBs on the
primary key
It would show data in all fields that don't match between MDBs
The urgent requirements are #2 and #5. I can do #1 using the MSys tables if
it's not in the tool. #3 and #4 are not critical, and I see there are
already tools out there for comparing MDB structures. I need to compare the
data primarily.
Thanks much! -Max
I'm looking for a tool or technique that will compare the data in two MDB
databases. The ideal result would be a report that shows:
1. A list of all tables in each MDB
2. Record count for each table in each MDB
3. Table Delta: tables that exist in one MDB and not the other
4. Field Delta: fields that exist in only one MDB (where the table is in both)
5. Data Delta: data that is not the same in both MDBs
The tool would link tables with the same name in both MDBs on the
primary key
It would show data in all fields that don't match between MDBs
The urgent requirements are #2 and #5. I can do #1 using the MSys tables if
it's not in the tool. #3 and #4 are not critical, and I see there are
already tools out there for comparing MDB structures. I need to compare the
data primarily.
Thanks much! -Max