/

Oracle to MySQL Effort

Oracle to MySQL Effort

Owned by Cameron Ahana

Last updated: Dec 10, 2024

ITS Admin will remain on Oracle. The conversion to MySQL has been canceled.

Estimated Effort

Task	Team	Effort Estimate
Create database	DBA	1 day
Data migration includes validation of table counts before and after migration installing Etlalchemy	DBA	5 days
Code refactoring 20 classes configuring extra datasources	ES	10 days
Testing	ES	10 days
TOTAL		~1 month

Erik's notes on migrating data and data structures using Etlalchemy

converts datetime to the correct type

Changes

new mysql driver
update the token files to reference mysql
how to add multiple data sources
virtual tables in sql need to be converted to views
using ||, need to replace with concat function
update references to sequence numbers
row_number() over (partition by...)
functions
- max
SQL converter
- http://www.sqlines.com/online
database links
- HR datamart
  - PSEMPL@DATAWAREDB_LINK.DB.UH
  - PSACCT@DATAWAREDB_LINK.DB.UH
  - HR_CURR_EMPL_SUPV_TBL@DATAWAREDB_LINK.DB.UH
  - See Screenshots:
- SECE database
  - SECEDB_LINK.DB.UH
  - StdDirectoryModel.java
    - joining sece tables with itsadmin's SECTION table
  - StudentModel
    - joining with itsadmin's PERSPOSITION table
  - StdSearchModel
    - joining with itsadmin's PERSPOSITION, SECTION tables
  - StdSearchRegModel
    - joining with itsadmin's PERSONNEL, PERSPOSITION, SECTION tables