====== Implementation Plan ====== Please use the [[implementation_plan#Naming_Scheme]] at the bottom of this section as a key for explaining unknown terms. ===== Tasks ===== - **Establish two seperate environments:** 'production' and 'test' - **Oracle Address space** creation by a DBA for our test environment - **'test' environment** will contain the tables that currently exist - Create the tables - Copy the MS Access database and work on the copied version for setup and testing below. - Setup any ODBC table links needed - Populate data into 'test' environment tables - Basic testing of the copied Access database environment by running existsing reports, forms, etc. - **User testing** - **Go live** - Halt operations on 'production' system - Populate 'test' system with 'production' system data - Do a quick test of system working through Access - Switch all users to 'test' system - 'test' system is now the **current production system**! ===== Naming Scheme ===== ==== Names ==== ^ Logical system name ^ Oracle Schema.table name ^ | production | | | test | GRAD_FAC_OWNER. FIXME | ==== Descriptions ==== **'production'**: This is the current system that is considered to be production at the time; It should change once during the implementation. It starts off as the original, all MS Access database system. **'test'**: This is the Oracle database system that simply brings the original tables over in the same format.