There is a production DB that is used by user. I made a copy of the DB and made changes to a table (added few columns) and then changed the form for that table. I don’t want to redo the changes I did within the production database. Is there an easy way to import those changes into the production DB– like import the whole table and the whole form – if that’s possible? Secondly doing it, the form will still work? Its reference for that table will not break if tis pushed to a different DB?
What are some best practices you guys conduct to do such change between test db and production db?