Compare data in two databases

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
Click to expand...

Total Access Detective from FMS does all this: http://www.fmsinc.com


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Try http://www.softwareaddins.com

They have reasonably priced tools that do what you want. CompareWiz provides
a pretty straightforward "what's different?" answer (including record
counts and some data I think) and may be all that you need (although you may
need to run it twice to be sure you get "missing" items: A vs. B and B vs
A). I think they have another tool that does a more intensive data
comparison as well but I'm fuzy on the details.
 
If you are interested in Comparing data you need CompareDataWiz not
CompareWiz
CompareDataWiz will find:
• All different records between the two databases.
• All identical records between the two databases.
• All records that exist in the first database but not in the second.
• All records that exist in the second database but not in the first.

CompareWiz on the other hand compares the two structures of (tables,
forms, fields, modules ...) and outline the diffrences.

Ken Adams
Software Add-Ins
------------------------------------------------------------------------------
Software Add-Ins Products:

CompareWiz, MS Access Database compare utility.
(http://www.softwareaddins.com/CompareWiz.htm).

ReplaceWiz, Global find and Replace for MS Access.
(http://www.softwareaddins.com/ReplaceWiz.htm).

CompareDataWiz: Compare between MS Access data.
(http://www.softwareaddins.com/CompareDataWiz.htm ).
 
Ken Adams said:
If you are interested in Comparing data you need CompareDataWiz not
CompareWiz
CompareDataWiz will find:
• All different records between the two databases.
• All identical records between the two databases.
• All records that exist in the first database but not in the second.
• All records that exist in the second database but not in the first.

CompareWiz on the other hand compares the two structures of (tables,
forms, fields, modules ...) and outline the diffrences.

Ken Adams
Software Add-Ins
------------------------------------------------------------------------------
Software Add-Ins Products:

CompareWiz, MS Access Database compare utility.
(http://www.softwareaddins.com/CompareWiz.htm).

ReplaceWiz, Global find and Replace for MS Access.
(http://www.softwareaddins.com/ReplaceWiz.htm).

CompareDataWiz: Compare between MS Access data.
(http://www.softwareaddins.com/CompareDataWiz.htm ).
Click to expand...
 
Back
Top