In June of 2006, the Saskatchewan Teachers' Federation (STF) successfully completed a 2 month project to upgrade their production database systems to Oracle 10g Release 2.
ESTI is pleased to announce the successful completion of this database upgrade project that was undertaken jointly by the STF and ESTI. The STF database server was being cycled out of production and the decision was made to jump ahead from Oracle 8i to Oracle 10g Release 2. Oracle 10g Release 2 is claimed to be the most stable and easy to use database server product ever released from Oracle Corporation.
Dwight Beech - IT Manager, STF, Patrick Lo - IT Summer Student, STF
The project was initiated with the purchase of new database server hardware. The STF decided on an HP Proliant DL380 with an external drive enclosure for expanded storage capacity. The hardware is x64 compatible, leaving the STF with an upgrade path to Microsoft and Oracle x64 technology.
Once the database server was configured with Windows 2003 Enterprise server, the database upgrade commenced. Oracle 10g was installed in a test environment and ESTI Consulting Services performed a test migration. ESTI then recompiled all of the existing Oracle 6i forms and reports against the 10g test environment to ensure application compatibility. These forms and reports were put through extensive user acceptance testing and signed off by each department at the STF. The project culminated with the production migration on the weekend of June 10, 2006.
Lawrence Cheng - ESTI Analyst, Jeff Banow - ESTI Senior Analyst
A number of major in-house systems, which are hosted by the STF, were positively impacted by this upgrade through feature and performance enhancements. These include a number of pension and benefits systems, Long Term Disability and Life Insurance applications, and the Green File imaging system. Online web applications were also impacted including a member information system and web remittance system.
Below is a list of the new features contained in Oracle 10g Release 2:
Congratulations to the Saskatchewan Teachers' Federation on successfully completing this database upgrade, keeping them in the forefront of database technology to improve the delivery of services for its members across Saskatchewan.
ESTI Consulting Services provided end-to-end services for Oracle 10g Release 2 upgrade project including: