asked on

Compare data in two tables

I have two tables

table a on server a
and
table a on server b

is there a way to compare the data from each other and report the differences.....and what column this is.

A bit complex i know but i was hoping there was a way...

I know how to compare two columns in one table.

SOLUTION

dave4dl

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

jefftwilley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Aneesh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dave4dl

aneeshattingal,
I think Traceymary was looking for differences in data, not the structure

SOLUTION

mnrz

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Aneesh

If you are looking to compare the data use the SQL Data Compare tool from

http://www.red-gate.com/products/SQL_Data_Compare/index.htm

ASKER CERTIFIED SOLUTION

Lowfatspread

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TRACEYMARY

ASKER

That some good ideas....did not think about doing in say asp read both recordsets.
That i can do quite easily......
the tool sounds good

This is probably not the first time i had to do this...i did it before comparing a two gig database but i was just comparing record counts ....this time its actual data.

Let me play with it....thanks all

TRACEYMARY

ASKER

i just looked at the red gate software it says databases i hope it goes down to tables...i am downloading it to see..

Thanks...that save me some time...in writing a hugh script.