I have two separate environments - staging and production. As of right now, both databases are absolutely identical, including data.
The structure of the staging database always changes during development - new tables, new fields, new changes.
I'm having difficulties with the transfer of staging DB to production.
I would like to migrate only the structural changes, without any data, when I deploy a new version to production.
Has somebody ran into similar problem? How can I make this process less painful?
Thank you!