deploying database updates
I have a custom filemaker app I use for production coordination at my business. We have several facilities that all use an independent but seperate instance of this application. I'm wondering if there is a best practice for deploying updates to this software. Currently I have a "development" instance, and when I'm ready to deploy updates I have to create several copies of this database and then manually import all the records from the "live" databases. This process is time consuming and leads to various errors and discrepencies between which version is live at each site. Is there a better method for managing this?