Compare two different databases

Question

I have two databases, DB mysql & DB Access.
I want to compare two the same tables from this different databases about data and schema. I need a tool for do it. Can you help me!

score 5 · Answer 1 · answered Jan 16 '20 at 15:34

5

With DataGrip, you can select 2 databases, right-click and select Compare.

answered Jan 16 '20 at 15:34

Philippe

4,088
4
44
49

score 1 · Accepted Answer · answered May 04 '17 at 12:30

If it is only for 2 tables with identical columns, the best way would be to extract the data into and ordered csv and use a diff tool to compare the files. If you want to compare many tables and the table structure you'll need to extract each in turn.

score 0 · Answer 3 · edited May 23 '17 at 12:17

0

I don't know if it the best but IBM Data Studio can do that if I'm report to this post.

edited May 23 '17 at 12:17

Community

1
1

answered May 04 '17 at 12:25

Francois Borgies

2,378
31
38

score 0 · Answer 4 · answered May 04 '17 at 12:27

0

You could use JetBrains IDE data grip and dump both files out and then compare using either excel or CLI

answered May 04 '17 at 12:27

Mike Tung

4,735
1
17
24

Compare two different databases

4 Answers4