Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

Open source DB tools

hi,

what kind of database management tools you guys can suggest for mariaDB ?

we are migrating from Oracle to MariaDB and because of the tools limitation, we can see that some tools, like mySQL workbench can't see all index migrated but some of the index can be seen from Toad for MySQL. but not all information like constraint can be seen from Toad for MySQL.

please suggest,
SOLUTION
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece 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
SOLUTION
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
SOLUTION
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
ASKER CERTIFIED SOLUTION
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
Avatar of marrowyung
marrowyung

ASKER

DAvid,

I migrate orable table to MariaDB but when Need to check constrain, foreign key , index and primary key, diff tools shows diff content!

verified with Ispirfer tools and they confirm diff toos display differently!

e.g. using MysQL workbench, I can't see index migrated  !! empty !

but using old Toad for MySQL 8.0 it can but index is not accurate!

what I want is, once migrated, I can use SLQ developer for Oracle to check diff in DB structure and using other tools to check MariaDB if the table schema is the same !

any free tools for MariaDB that keep having update and can show all necessary information in accurate format ?

this issue is interesting as no one will bevliev that once migrate to MariaDB , UI  tools can't see EVERYTHING migrated
I am thinking about what if compare MariaDB result with Oracle using the SAME SQL developer ! SQL developer can connect to mariaDB.
Tomas Helgi Johannsson,

that tools ask for MariaDB driver, which one you use ?  all my other tools: SQL developer and Toad for MySQL do not need that.

User generated image
hi, any update for me ?
david:

"You can always use phpMyAdmin, if you're set on having a GUI tool."

windows web edition ?
Have you checked my recommendations ?
For phpWebAdmin you need a Web server (easiest would be Wamp/Xampp) ...but dbforge is far superior to all the others mentioned...
".but dbforge is far superior to all the others mentioned..."

actually consider this beforer but this one can't compare result set, that's why I don't continue with this anymore!

we consider AQua data studio however.

and I just have one more steps left on setting up DBwaver, so I focus on it.
I am pretty sure that if you have specific needs then probably you need a specific tool....if you elaborate a bit on the
compare result set
maybe you will get some better help.
"maybe you will get some better help.

Aqua data studio purchased by Idea can do the job! this tools can connect to a lot of dB we knew.
Aqua Studio carries a price ...if you check the paid version of Dbforge has all kind of compares and if i am not mistaken at a much lower price.
"Dbforge has all kind of compares"

it is not ! I checked!

Toad Edge for MySQL also can't !

the point is, both 2 x above can't compare result set from 2 x diff DB.
this is what I tried:

1) dbforge for MySQL:

constraint shown for MariaDB:

User generated image
index shown for MariaDB:

User generated image
HeidiSQL can only shows index but not constraint:

User generated image
using SQL developer for Oracle what we can see is the index and constraint hows in diff way:

constraint:

User generated image
index:

User generated image
you all can see that all tools shows things differently, how can I compare them easily using GUI tools

HeidiSQL really can't show constraint ?
tks all
tks all