Devart Forums

Hey,
I have 2 databases, 1 is dev and 1 is prod. how can i deploy the structure from the dev database to prod without erasing all it's data?
I tried to create a backup of structure only from the dev and restore it on the prod (it completely erased everything)
I tried to make a diagram from dev but couldn't find a way to apply it to prod..

Am I missing something?

Please try using the Schema Compare feature https://docs.devart.com/studio-for-mysq ... rview.html

The following demo videos may be also of help:
https://www.youtube.com/watch?v=Nn-Z9GOCaxQ
https://www.youtube.com/watch?v=FsZwws46GD0