We update our existing volunteer database with enough new features that we would like to release for limited use. The team will continue modify the new db with user feedbacks. We; however, not sure on how to deploy new features once we release the db. We develop and test new features offline but do not see a way to copy the layout and scripts over to the production one. Is there a way?
We also don't want to import and export data over to the new database everytime we release new features. We would like to reserved existing data (user randomly created login credential, person who approved the volunteer, etc)
Anyone has a strategy that allow you to release new features by adding them into an existing database?
Thank you for your advice,