Menu
How do I forward engineer my MySQL Model in the MySQL Workbench without losing the database's table rows?
I basically have a remote database with a users table with tuns of users in it. I also have a MySQL Model with the model of that remote database. In the model however, I have added 1 extra column to the users table. How do I add that column to the remote database without losing all users?
I have set a default value for the new column if that is a problem.
920
9.4.1 Forward Engineering 9.4.2 Reverse Engineering. MySQL Workbench provides capabilities to forward engineering physical database designs. A visual data model can be transformed into a physical database on a target MySQL Server by executing the forward engineering wizard.
With MySQL Workbench, you can reverse-engineer a database using a MySQL create script or you can connect to a live MySQL server and import a single database or a number of databases.
Click on Database -> Synchronize Model or simply press Shift + Control + Z. A synchronization pop-up dialogue will appear and guide you through the process.
141
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
