MySQL Forums
Forum List  »  MySQL Workbench

Best practice modelling with data
Posted by: jhskfh kjhfkjs
Date: July 14, 2015 05:16AM

Hi,

Ive just started out with SWB and I have a question about how you as serious users use it in a best practice way.

Currently, Ive built a candidate ERD and Ive started populating it with data to test out relationships and queries. As something isnt quite right, I modify the tables or keys to be more reflective of what I need. Each time I modify the schema though, I have to reload all the data in from scratch which is torture.

Even if I selectively drop individuals tables and dont drop the whole schema because some of the FKs have changed I get errors and often have to rebuild entirely. This doesnt seem particularly effective.

Is there a better way of building and testing the data model with real data?

Thanks very much in advance.

Will

Options: ReplyQuote


Subject
Views
Written By
Posted
Best practice modelling with data
894
July 14, 2015 05:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.