Implementation Plan

Please use the Naming_Scheme at the bottom of this section as a key for explaining unknown terms.

1. Establish two seperate environments: ‘production’ and ‘test’
2. Oracle Address space creation by a DBA for our test environment
3. ‘test’ environment will contain the tables that currently exist
   1. Create the tables
   2. Copy the MS Access database and work on the copied version for setup and testing below.
   3. Setup any ODBC table links needed
   4. Populate data into ‘test’ environment tables
   5. Basic testing of the copied Access database environment by running existsing reports, forms, etc.
4. User testing
5. Go live
   1. Halt operations on ‘production’ system
   2. Populate ‘test’ system with ‘production’ system data
   3. Do a quick test of system working through Access
   4. Switch all users to ‘test’ system
6. ‘test’ system is now the current production system!

‘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.