I have a simple model designed and exported it and set up a database from that.
Now I want to update my model with new tables and references and export this as well and then update my database.
I tried to do that, but when I imported it to my existing schema, it didn't have all columns and references only some of them.
I use MySQL workbench to manage my MySQL database.
Would I need to make a need schema with the new exported model and then migrate the new one to the old one using something like Flyway? Or how would one do this?
Sorry if this is a very basic question or it is unclear what i am asking. I am rather new to SQL databases.
Customer support service by UserEcho