Compare tables in two different databases tool
I am using Toad. Often I need to compare tables in two different test environments. the tables they contain are the same, but the data is different. I just need to know what are the differences in the same tables that are in two different databases. Are there any tools that can be installed on windows and used for comparison.
source to share
I would definitely go with AdeptSQL if you are using MSSQL. This is the least attractive but most talented db comparison tool I have tried. It can compare both structure and data. It tells you which tables exist on one db but don't exist on the other, compares the structure and data of the common, and can generate a script to keep the two in sync. It's not free but has a 30 day trial (as far as I remember)
source to share
Try dbForge Data Compare for SQL Server . It can compare and synchronize any databases, even very large ones. Fast, easy, always delivers the right result. Try in your database and comment on the product.
source to share
If you want to do it online there is a free DB Matcher tool where you download 2 files and it gives you the differences .SQL
source to share