MySQL Forums
Forum List  »  MySQL Workbench

Synch errors due to not dropping foreign keys?
Posted by: Marc Ford
Date: January 29, 2009 11:01PM

I consistently have synch problems after altering fields or adding new tables or fields and their relationships. If I delete the foreign keys surrounding the "problem" table in the target database, the synch process will complete successfully. It appears that Workbench needs to learn when to DROP foreign keys so that changes can be made, and then re-insert the foreign keys at the end of the script after the changes have been made.

When I synch 2 actual databases using SQLyog, their script shows this action. FK's dropped at the beginning, and then you seem them being reinserted at the end.

I really love the Workbench ERD tool and don't want to give it up, but synching will become unmanageable soon if I have to constantly delete foreign keys so the synch can take place.

Please let me know if I am in error...

Options: ReplyQuote


Subject
Views
Written By
Posted
Synch errors due to not dropping foreign keys?
5103
January 29, 2009 11:01PM


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.