Tool Compare the tables in two different databeses

Question

I am using Toad. Frequently i need to compare tables in two different test environments. the tables present in them are same but the data differs. i just need to know what are the differences in the same tables which are in two different data bases.Are there any tools which can be installed on windows and use it to compare.

Much appreciate your help:)

Answer 1

Maybe a similar question would help you.

Answer 2

Take a look at SQL Compare and SQL Data Compare

Answer 3

There's a compare tool built into TOAD. Tools | Compare Data.

Answer 4

Zidsoft CompareData http://www.zidsoft.com/ is free for comparing table data (no expiration) and offers per column settings for comparing data

Answer 5

Hi there,

If you are using SQL Server, then you might want to give a try to Volpet's Table Diff:

http://www.volpet.com/

You can try a fully-functional copy for 30 days.

Please let me know for anything.

Thank you, Giammarco Volpet Software

Answer 6

I would definitely go with AdeptSQL if you're using MSSQL. It's the least good looking but the most talented db compare tool amongst the ones I've tried. It can compare both the structure and the data. It tells you which tables exist on one db but does not exist on the other, compares the structure and data of the common ones and it can produce the script to synchronize the two. It's not free but has a 30 day trial (as far as I can remember)

Answer 7

Try dbForge Data Compare for SQL Server. It can compare and sync any databases, even very large ones. Quick, easy, always delivers a correct result. Try it on your database and comment upon the product.

Answer 8

DiffKit is an Open Source project that does exactly what you are looking for.

http://www.diffkit.org