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.
LVL 16
Easwaran ParamasivamAsked:
Who is Participating?
Guru JiConnect With a Mentor Commented:
I use this

Its free for 14 days trial but if you need something aftewards free then you can use this

Hope that helps
Aneesh RetnakaranDatabase AdministratorCommented:
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
David L. HansenProgrammer AnalystCommented:
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?
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Surendra NathTechnology LeadCommented:
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.
David L. HansenProgrammer AnalystCommented:
Neo_jarvis, How exactly do you do that...which tool?
Easwaran ParamasivamAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.