Tabs tab performed in Editing MySQL Chart Table in Workbench EER?

Question

I needed to paste some source data (by default) into a new database, and I found the “Insert” tab in the edit form of the Microsoft Workbench EER tool table

My assumption was that I can use it to insert the original (default) data that will be distributed to the database during synchronization (not sure how it will be merged with any existing data in the database, though ...) . I added a couple of lines and a synchronized model with an empty database, but no data was inserted.

So my question is , what is the Insert tab on the Edit Table screen?

I am using MySQL Workbench 6.

PS If someone can point out a simple way to insert the source data (by default) (except for a simple SQL script run), I will be grateful for this.

Thanks.

Answer 1

The data added on the INSERT page is indeed considered the original set of (test) data. However, it does not examine existing data. I think that it is also used only if you are performing forward techniques and not synchronization.

Other ways to insert data always include an SQL script that the API (text) is for SQL servers. But you can also add scripts to your model (see the Overview page). However, they do not start automatically.