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,
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am thinking about what if compare MariaDB result with Oracle using the SAME SQL developer ! SQL developer can connect to mariaDB.
ASKER
ASKER
hi, any update for me ?
ASKER
david:
"You can always use phpMyAdmin, if you're set on having a GUI tool."
windows web edition ?
"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...
For phpWebAdmin you need a Web server (easiest would be Wamp/Xampp) ...but dbforge is far superior to all the others mentioned...
ASKER
".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.
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 setmaybe you will get some better help.
ASKER
"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 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.
ASKER
"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.
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.
ASKER
this is what I tried:
1) dbforge for MySQL:
constraint shown for MariaDB:
index shown for MariaDB:
HeidiSQL can only shows index but not constraint:
using SQL developer for Oracle what we can see is the index and constraint hows in diff way:
constraint:
index:
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 ?
1) dbforge for MySQL:
constraint shown for MariaDB:
index shown for MariaDB:
HeidiSQL can only shows index but not constraint:
using SQL developer for Oracle what we can see is the index and constraint hows in diff way:
constraint:
index:
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 ?
ASKER
tks all
ASKER
tks all
ASKER
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