Does anyone know of software that can be used to compare two tables? I have searched the web and I see commercially available software for comparing entire database schemas, however these seem geared toward comparing a new version of a database versus a previous version, so it will probably just give me a list of field names that are different.
My situation relates to a change in data sources that are imported for a downstream application. Not only have the field names changed, but we need to run the two sources together in parallel to make sure the field values are still the same. So what I am interested in is something that would allow me to
1.) Link up the data sources via ODBC
2.) Enter in a cross-reference to map each field in the new table to the corresponding field in the old table.
3.) automatically compare each field (new table vs. old table) for each record, and list differences.
I was thinking of writing something to do this myself, but it seems a little tricky. It would be great if I could find something already available.
My situation relates to a change in data sources that are imported for a downstream application. Not only have the field names changed, but we need to run the two sources together in parallel to make sure the field values are still the same. So what I am interested in is something that would allow me to
1.) Link up the data sources via ODBC
2.) Enter in a cross-reference to map each field in the new table to the corresponding field in the old table.
3.) automatically compare each field (new table vs. old table) for each record, and list differences.
I was thinking of writing something to do this myself, but it seems a little tricky. It would be great if I could find something already available.