Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 2 Next »

Estimated Effort

TaskTeamEffort Estimate

Create database

DBA1 day

Data migration

  • includes validation of table counts before and after migration
  • installing Etlalchemy
DBA1 day

Code refactoring

  • 20 classes 
  • configuring extra datasources
ES10 days
TestingES10 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
  • database links
    • HR datamart
    • 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



  • No labels