Link to home
Start Free TrialLog in
Avatar of Stephen Lappin
Stephen LappinFlag for United Kingdom of Great Britain and Northern Ireland

asked on

What types of database can be modelled with MySQL Workbench?

What type of databases are supported by MySQL Workbench for data modelling (including forward engineering)?

For example, can I model and forward engineer to any of:
  • Oracle
  • SQL Server
  • PostgreSQL
  • Aurora
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

You can use any modeling tool to generate logical models for anything.

I've note seen where it can generate pluggable DDL for any other database than MySQL.  Then again, I've only ever used it to create MySQL databases so never had the need to look.

The docs don't mention anything about other database options:
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-sql-scripts.html
each Vendor tries to set tool for their product for the best results:
I'd use MySQL Workbench for Mysql only
for Oracle Free

SQL Developer Data Modeler
http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html

or just use Visio

with
Visio Forward Engineer Addin
https://forwardengineer.codeplex.com/


as an universal tool
you can use Erwin  http://erwin.com/products/data-modeler/

ER\Studio
https://www.idera.com/er-studio-data-architect-software/productdetails
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.