Running Parallel

We are going to be running parallel with a new system and I will need to compare old versus new. Does anyone know of any reusable code or technique that compares similar but not exact tables and creates an exception report. -- Lee Surma Public Radio International [EMAIL PROTECTED] 612-330

RE: Running Parallel

We are going to be running parallel with a new system and I will need to compare old versus new. Does anyone know of any reusable code or technique that compares similar but not exact tables and creates an exception report. If you're talking about comparing the database schema, as opposed

Re: Running Parallel

If you're talking about comparing the database schema, as opposed to the data within the tables, I'm talking about comparing the data within the tables. Start out with identical data, do a bunch of data entry to both systems, compare the data. I'm envisioning some code where you input the data

RE: Running Parallel

I'm talking about comparing the data within the tables. Start out with identical data, do a bunch of data entry to both systems, compare the data. I'm envisioning some code where you input the data sources, the table names, the matching field names, do a bunch of queries and or loops