Database comparison software

[newtonrealman]

Hi!

Do you guys know any software/web app that allows you to generate reports stating differences between two tables?

I found comparezilla, but all it does is checks rows from top to bottom and see if they are the same ... eg:

Table 1

1. A

2. B

3. C

Table 2

1. A

2. B

5. E

all it would detect is that the third row is different ... not that rows 3 & 4 are missing from table 2.

Any ideas?

Newton

[+Nik Louch Subscriber²]

Rows are missing? The rows are not missing and I think you need to look at how you perceive database tables.

They are only row 1,2,3 in the way you have sorted them. They are not always given in that way. This is why an ID field is useful.

Anyhow, how large are your tables?

[newtonrealman]

yeah, the numbers on the left are the ids (primary key)

Tables are quite big, say about 200 rows +

[+Nik Louch Subscriber²]

Are we using MS SQL?

200 is very very small. OK, there's a few ways to accomplish this, but I don't have an SQL instance to hand...

How about you create a left join on the IDs, then use WHERE statements to see what doesn't match?

[BGM]

you can use either redgate sql compare (free for 14 days)

or you could also use visual studio 2005 / 2008 database edition, which has a database schema & data comparison tool.. although imo it is not as good as redgate.

good luck!

[newtonrealman]

sorry, meant 2000 +

will be using mainly oracle, but would be amazing if the tool would be able to compare other db's too

gonna check out redgate now ...

[newtonrealman]

also was searching an opensource software.

Cross-Database Comparator is one, but its not free.

Any ideas?

[newtonrealman]

looking for something similar to the following screenshot

database_comparator.bmpFetching info...

[tomwarren Veteran]

No need for capitals. Title edited.