Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I've made an ERD in MySQL Workbench, where I added foreign keys to visualize the relationships. In the actual database I want to work without the foreign keys (I'll organize that in my application).

When I export a create script, there is somewhere a function called "skip creation of foreign keys" or anything like that.

Now I want to sync the model directly with my database, but it looks like there is no equivalent option in the synchronization function.

I can also not find this option in the wizard for exporting an alter script, which would also be ok.

Am I just missing it or is that impossible?

share|improve this question
    
Workbench is trying to protect you from the dangerous choice of having no FKs :) –  ypercube Jul 3 '13 at 14:07
    
I think there are pretty long discussions about the pros and cons. After reading for 2 hours and maybe 1/1000 of it I decided to go without. :D –  Marcel Jul 3 '13 at 14:11
    
Don't do it. Why don't you leave the FKs there? And still deal with them ("organize") in the application. It doesn't hurt, really to have everything double checked. Plus, you can sleep at night without fear of the database losing data integrity. –  ypercube Jul 3 '13 at 14:13
    
Maybe I add them later on, I don't know. Right now it would just get on my nerves because I have a lot of changes and the fks are always crying. –  Marcel Jul 3 '13 at 14:21
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.