CODEWITHSUNDEEP
mysqlmysql-workbencherd
klaytonbrito
klaytonbrito

Reputation: 123

MySQL Workbench 6 - difference in creating database / schema as a model and within a MySQL Connector

I was rooting MySQL Workbench and I had a TILT. In MySQL Workbench initial screen there are two things I did not understand.

What I wanna know is:

  1. Why there are options of create schemas / databases as models and within MySQL Connections?

  2. why I can create schemas / databases with the same name in both options to create schemas / databases (MySQL Connectors and Models) without naming conflicts happen?

  3. If they are the same thing, why when I create a model MySQL Connector does not synchronize automatically to recognize the model?

  4. If they are the same thing, that I can create EER Diagram for schema / database in the Model and not in MySQL Connector?

Thanks to anyone who can answer me these questions.

Upvotes: 1

Views: 3833

Answers (1)

Mike Lischke
Mike Lischke

Reputation: 53532

You started from the wrong premise. Models and connections are two completely different things (why would there be different sections in MySQL Workbench if not?).

Via connections you can reach a server and work on it. Create users, retrieve data, create db objects etc.

Modeling is however the task to design a database structure. All the objects you create only exist within that model. You can design your structure from a higher level of view instead of going down to the pure SQL (which you can too, if you want). Nothing reaches a server until you either forward engineer your model or synchronize it to that server. The first is simply creating all the objects as you designed them, the latter is a two-way 'merge', that is, a diff is generated between the model and the server content and changes are applied to make the structure on the server be the same as in the model and vice versa.

Understanding that fundamental difference answer all your questions above.

Upvotes: 5

Related Questions