Skip to main content

2024 HANA Database Migration

This technology project will move the myNKU/SAP application to an SAP HANA (High-performance ANalytic Appliance) database.  Moving to this modern database will allow us to process more data in a shorter amount of time.  This is primarily a technology project, although we will have some functional areas involved for testing.  All changes will occur in the backend.  Our users can expect no changes to the functionality in myNKU.

If you have any questions/concerns, please contact us.

Project Timeline
Jan 15th - Feb 16th
ERS Migration
1/15 - 1/19 (5 Days)
DB2 to HANA Migration
14 Days
Validation and Testing
 
Feb 19 - Apr 5
ERD/BWD Migration
 
Campus Communication: IT Newsletter
2/19 - 2/23 (5 Days)
DB2 to HANA Migration
14 Days
Validation and Testing
Apr 8 - May 17
ERQ Migration
 
Campus Communication: IT Newsletter
3/25 - 3/29 (5 Days)
DB2 to HANA Migration
14 Days
Validation and Testing
 
May 23
ERP/BWP Mock Tabletop Exercise
 
Walkthrough and update all procedures
Friday May 24, 2pm
ERP/BWP Migration
Friday May 24, 3pm
ALL SAP/BW SYSTEMS UNAVAILABLE
 
Campus Communication: IT Newsletter, emails
5/24 - 5/27 (3 Days)
DB2 to HANA Migration
5/27 - 5/31 (5 Days)
Validation and Testing
5/31
All ERP and BWP functions returned to normal operations
 
End of Migration through June 30
Critical Care Period
TBD (soon after production cutover)
DR Test
Sandbox(ERS)
Development (BWD and ERD)
QA
(ERQ)
Production(ERP and BWP)
Post-Production Support
Sandbox
(ERS)
Development
(BWD and ERD)
QA
(ERQ)
Production
(ERP and BWP)
Post-Production
Support
January 10 - February 9

Sandbox (ERS) Migration

The first phase will move the sandbox environment (ERS) to the HANA database. This is a test environment used by IT to test new functionality, patches, etc.

The anticipated downtime dates for migration are January 22nd - January 26th.

Status: Green, Closed

  • Database migration successfully completed 2/14
  • Testing started and basic database testing completed
  • Long term ERS system operations being planned
  • Testing has completed successfully
February 12 - March 21

Development Environment (BWD and ERD) Migration

The second phase will move the development environment (BWD and ERD) to the HANA database. This is a test environment used by IT to test new functionality, patches, etc.

The anticipated downtime dates for migration are February 29th - March 6th.

Status: Green, Closed

  • Database migration successfully completed 2/26
  • System testing started 2/27. Estimated to complete 3/12.
  • Tax software provisioning delayed by SAP for 3 weeks, delaying completion of ERD testing (does not impact the overall production cutover schedule)
  • Testing has completed successfully
  • Payroll was successfully tested by the functional area
March 22 - April 23

QA Environment (ERQ) Migration

The third phase will move the QA environment (ERQ) to the HANA database. This is a test environment used by IT to test new functionality, patches, etc.

The anticipated downtime dates for migration are April 2nd - April 8th.

Status: Green, Post-Migration Prep Work and Functionality Testing

  • Initial planning started 2/26
  • Base system buildout scheduled for 2/28 - 3/1
  • Database was migrated successfully. IT is currently reconnecting the web portal and other functionality.
  • Testing started 4/17
  • The transport process is available to use for system changes
May 13 - May 31

Production (ERP and BWP) Migration

The fourth phase will move the production environment (ERP and BWP) to the HANA database. This is the live myNKU environment used by NKU.

The anticipated downtime dates for migration are May 24nd - May 30th. This covers Memorial Day and that week.

Status: Green

All activities in this phase are progressing as expected.

Go Live: May 31

Post-Production Support

The fifth phase will provide support for all myNKU users after the migration to the HANA database.

Status: Green

All activities in this phase are progressing as expected.