I have an app running on a staging database. I added about 8 fields to a table, a users table, and a button on a List that runs a little code snippet. The app is for managing email templates and result emails.
I want to point the app at the production database now.
My temptation is to change the database connection on the Tables tab, but when I have done that before, I lose all the configuration of the app, even when replacing the database with a virtually identical one, so I don't want that.
I think the action is to manage the database connection and FTP destination on the output screen, making sure to use dev-dev and production-production settings and not mix them?
The other to do is to manually keep the databases in sync?
Is this the best way to maintain dev and production instances of a PHPR app?
Thanks in advance.