douglerner

Moving scripts and other database structures between a dev db and production db

Discussion created by douglerner on Mar 4, 2016
Latest reply on Mar 4, 2016 by NickLightbody

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?

 

Thanks,

 

doug

Outcomes