synchronization between db, orm and workbench

0 votes
asked Jul 25, 2014 in Solved by kukoman (340 points)

hi;
i imported workbench project into the orm designer, i made some changes, now how do i synchronize the workbench & db?
Or
I made some changes directly in DB and want to synchronize ORM designer project, how to do that?

1 Answer

0 votes
answered Jul 25, 2014 by Martin Freki Stradej Skipper developer (74,840 points)
selected Jul 25, 2014 by kukoman
 
Best answer

Hello,
Direct synchronization with the DB is not possible, but it is also not necessary:

You can export the changes to your project as ready-to-use ORM schema definitions and use your ORM framework functions to generate the database from it.

If you need to do some changes, it is strongly recommended to do them in the ORM Designer model and then generate new DB using the schema definitions and ORM framework. This is the only way to ensure the consistency of your model, definitions and database. This is also the fastest way because you are editing the ORM model, not the relational database that may be missing the ORM properties.

In case you do some changes directly in the database, it is necessary to import the whole project again, there is no synchronization possible.

...