Synchronize model in MySQL Workbench
Posted
by Álvaro G. Vicario
on Stack Overflow
See other posts from Stack Overflow
or by Álvaro G. Vicario
Published on 2010-04-15T14:13:45Z
Indexed on
2010/04/15
15:33 UTC
Read the original article
Hit count: 584
After reading the documentation for MySQL Workbench I got the impression that it's possible to alter a database in the server (e.g. add a new column) and later incorporate the DDL changes into your EER diagram. At least, it has a Synchronize Model option in the Database menu. I found it a nice feature because I could use a graphic modelling tool without becoming its prisoner.
In practice, when I run such tool I'm offered these options:
Model Update Source
================ ====== ======
my_database_name --> ! N/A
my_table_name --> ! N/A
N/A --> ! my_database_name
N/A --> ! my_table_name
I can't really understand it, but leaving it as is I basically get:
DROP SCHEMA my_database_name
CREATE SCHEMA my_database_name
CREATE TABLE my_table_name
This is dump of the model that overwrites all remote changes in my_table_name.
Am I misunderstanding the feature?
© Stack Overflow or respective owner