Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Copy 11 tables under schema mur_arch from Oracle to PG/Aurora #4465

Closed
3 tasks done
fec-jli opened this issue Jul 13, 2020 · 3 comments
Closed
3 tasks done

Copy 11 tables under schema mur_arch from Oracle to PG/Aurora #4465

fec-jli opened this issue Jul 13, 2020 · 3 comments
Assignees
@hcaofec
Labels
Work: Database
Milestone
Sprint 13.2

Comments

@fec-jli
Copy link
Contributor

fec-jli commented Jul 13, 2020 •
edited by hcaofec
Loading

Currently, all archived MURs data(11 tables and 1 procedure) is stored in oracle db, under schema: mur_arch, we need copy those to AWS Aurora DB and setup data syntonization.
11 tables (under schema: mur_arch):
cite
murao
murcit
murcom
murflm
murmst
murmst_bad
murrel
mursub
subjct
subjct_from_file

Ref issue: #4129

  • Create schema and all the 11 tables in Aurora postgresql databases (make sure migration file is submitted)
  • Initial data load into Aurora tables ( DEV, STAGE, PROD )
  • Put a copy of mur_arch data on google shared drive ( legal resources/mur_arch )
@fec-jli fec-jli added this to the Sprint 13.1 milestone Jul 13, 2020
@fec-jli fec-jli changed the title Copy schema mur_arch and 11 tables from Oracle to PG/Aurora Copy 11 tables under schema mur_arch from Oracle to PG/Aurora Jul 13, 2020
@hcaofec hcaofec self-assigned this Jul 13, 2020
@JonellaCulmer JonellaCulmer mentioned this issue Jul 16, 2020
Closed
This was referenced Jul 20, 2020
Closed
Closed
@hcaofec hcaofec mentioned this issue Jul 22, 2020
Merged
@fec-jli
Copy link
Contributor Author

fec-jli commented Jul 28, 2020

check the 11 tables on dev. looks good. Thank you.

This was referenced Jul 30, 2020
Closed
Closed
@hcaofec
Copy link
Contributor

hcaofec commented Aug 3, 2020

Initial data has been loaded into DEV. Loading into Stage and Prod are still pending.
After discussing with @ChingKuan, mur_arch will not be included in GoldenGate because the archived data will not be changed.

@hcaofec hcaofec modified the milestones: Sprint 13.1, Sprint 13.2 Aug 4, 2020
@hcaofec
Copy link
Contributor

hcaofec commented Aug 7, 2020 •
edited
Loading

Data has been loaded into STAGE and PROD.

@hcaofec hcaofec closed this as completed Aug 14, 2020
@fec-jli fec-jli mentioned this issue Aug 26, 2020
Merged
4 tasks
@rfultz rfultz mentioned this issue Mar 18, 2021
Closed
@patphongs patphongs mentioned this issue Mar 4, 2024
Closed
18 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hcaofec hcaofec

Labels
Work: Database
Projects
None yet
Milestone
Sprint 13.2
Development

No branches or pull requests
2 participants
@fec-jli @hcaofec