How to Update Multi-User Production Databases

If you are working with a multi-user database program, do not run the Schema Change Wizard on a project database where other users are currently making transactions. Instead, use the procedure below to update the schema:

1. Copy the production database from the server machine.
2. Perform schema changes on this copy of the production project database. Run Schema Change Wizard to implement these changes.
3. Test the changes on the updated copy of the production database.
4. Schedule down-time for the production database. During the scheduled down-time, ensure that all users are logged off of the database and that no one can log in during the scheduled down time.
5. User the Database Update Wizard to export the data dictionary from the test database and import to the production database.
6. User the Schema Change Wizard to make the changes to the production version of the physical database.
7. Test the changes on the production database.
8. Resume logins for the users.