What are best practices for moving scripts and other database structures between a dev db and production db?
You don't want to just copy over the dev db because the data is different.
I understand if you have FM Advanced you can copy scripts and paste them over. But does that have to be done script by script? How do you keep track of what changed and what didn't?
And what about table management, like changing field names, or relationship tables? Do you need to remember all the changes and then make the same changes at production? How do you keep track?
Or is there some way of exporting just the "structure" of a database and importing it to production, without copying over the data?