Link to home
Start Free TrialLog in
Avatar of Easwaran Paramasivam
Easwaran ParamasivamFlag for India

asked on

Compare two table data in SQL

Is there any tool or method available to compare same table from two different Databases?

I'm using tablediff command. Though it is useful I would like to know is there any free tool present to see the difference visually.

If you have or know please do share.
Avatar of Aneesh
Aneesh
Flag of Canada image

I use the redgate's  comparison tools although it is not free, you can use the trial version for 30 days. Apex and IDera has the similar tools
ASKER CERTIFIED SOLUTION
Avatar of Guru Ji
Guru Ji
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
What kind of differences are you looking for?  Just trying to find whole rows that exist in one but not the other?  Or are you looking for columns which have been added/removed from one relative to the other?  Or, perhaps just rows where a value has changed in one table but not the other.  Perhaps all of the above?
I will use the database compare shipped as part of VS 2010 and above versions, if you do have that then use it, it is a free tool.
Neo_jarvis, How exactly do you do that...which tool?
Avatar of Easwaran Paramasivam

ASKER

Thanks.