Cov txheej txheem:

Yuav ua li cas kuv migrate kuv Oracle database rau Amazon Aurora?
Yuav ua li cas kuv migrate kuv Oracle database rau Amazon Aurora?

Video: Yuav ua li cas kuv migrate kuv Oracle database rau Amazon Aurora?

Video: Yuav ua li cas kuv migrate kuv Oracle database rau Amazon Aurora?
Video: Цис тау юав кой лос цуав нёб коом зос 09.03.2018 2024, Hlis ntuj nqeg
Anonim

Hauv kev teeb tsa ua haujlwm:

  1. Xaiv qhov piv txwv replication uas tau muab los ntawm tus AWS CloudFormation pawg.
  2. Xaiv qhov Oracle endpoint raws li qhov chaw.
  3. Xaiv qhov Amazon Aurora MySQL endpoint raws li lub hom phiaj.
  4. Rau Kev tsiv teb tsaws chaw hom, xaiv Hloov chaw uas twb muaj lawm cov ntaub ntawv .

Kuj tseem paub yog, Kuv yuav hloov pauv lub Oracle database rau AWS li cas?

Rau tsiv teb tsaws koj cov ntaub ntawv rau AWS , koj xav tau qhov chaw database (xws li nyob rau hauv tsev lossis hauv ib lub chaw khaws ntaub ntawv) thiab qhov chaw nyob database hauv AWS . Raws li koj xav tau kev lag luam, koj tuaj yeem xaiv ntawm kev siv Amazon RDS rau Oracle los yog txhim kho thiab tswj cov database ntawm koj tus kheej hauv Amazon EC2.

Ib sab saum toj no, Amazon puas siv Oracle databases? Salesforce.com siv Oracle rau khiav lawv muag automation huab. SAP siv tus Oracle Database rau khiav lawv cov kev pabcuam huab thiab yuav luag tag nrho lawv cov neeg siv khoom hauv tsev. Txawm Amazon siv tus Oracle Database rau khiav feem ntau ntawm lawv cov lag luam. Tsis muaj lwm yam database ua tau ua uas.

Yog li ntawd, kuv yuav migrate Oracle database rau AWS redshift li cas?

Nov yog cov kauj ruam los rov ua dua Oracle DB rau Amazon Redshift siv Hevo:

  1. Txuas thiab teeb tsa koj Oracle database.
  2. Xaiv hom replication: Txhais cov ntaub ntawv thauj khoom los ntawm kev cai SQL query. Xaiv lub Oracle DB rooj yuav tsum tau thauj khoom ntawm interface.
  3. Configure Redshift Data Warehouse rau cov ntaub ntawv thauj khoom.

Dab tsi yog database migration hauv Oracle?

7 Hloov cov ntaub ntawv Siv Oracle Data Pump. Txhawm rau txhim kho kev txhim kho Oracle Database , koj tuaj yeem siv Export thiab Import utilities hauv Oracle Data Pump rau migrate cov ntaub ntawv los ntawm ib database rau lwm tus. Oracle Data Lub twj tso kua mis muab kev ua haujlwm siab Export (expdp) thiab Ntshuam (impdp) utilities.

Pom zoo: