database comparison tool for a small database file

I am comparing 2 database mysql .sql files

one is 18mb and the other is 31mb

but araxis merge file comparision keeps crashing

is there a good tool for comparing large files
LVL 1
rgb192Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sameer2010Commented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PortletPaulfreelancerCommented:
Are you sure you want to compare "as files"?
(which would be quite different to comparing databases)

Are you looking for differences in dbms schema or data or both?

Do you need to run this on Windows or Mac?
(I see araxis works on os/x)


A commercial tool with good reputation is by Redgate you might want to look at
- it does either or both schema and data comparisons:
http://www.red-gate.com/products/mysql/mysql-comparison-bundle/
a fully functional 14 day trial is offered

(nb: I have not personally used this and have no association with them)

mysqldiff might also work for you if only wanting schema differences, see:
http://adamspiers.org/computing/mysqldiff/
0
rgb192Author Commented:
most important: I am trying to see the difference in columns

optional: want to see inserts
0
rgb192Author Commented:
Okay I could use db comparison tools

Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.