CODEWITHSUNDEEP
mysqlmysql-workbenchdata-synchronization
Thorsten Kettner
Thorsten Kettner

Reputation: 95082

MySQL Workbench - Get data rows from model to db

I have made a model (EER / ERD) in MySQL workbench. With Database|Forward Engineering I got my data model into a local MySQL database. This has worked fine; I am seeing all the tables, constraints, indexes, ...

But I also have data rows in my model and I expected these to get inserted into the database tables, too. This has not happened.

I can synchronize model and db, but this always only affects the database structure it seems, not the data.

How do I get my data (table rows) from my model into my database?

Upvotes: 0

Views: 33

Answers (1)

Tanika Satalkar
Tanika Satalkar

Reputation: 36

You can export inserts from the Model by going to the File > Export > Forward Engineer SQL CREATE Script. Check Generate Insert Statements for Tables. Save the SQL file and then run the Script

Upvotes: 1

Related Questions