Tool Compare the tables in two different databases

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.

Take a look at SQL Compare and SQL Data Compare

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

Open Source DiffKit will do this:

www.diffkit.org

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)

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.

If you want to do it online, there is a free tool DB Matcher where you upload 2 .SQL files and it gives you the differences

https://dbmatcher.com