Perform Initial data load using from Oracle to YugabyteDB using Goldengate

In this blog, we’ll see initial data load process from Oracle database to YugabyteDB using Goldengate. 

Source - 

Oracle Database 19c

Goldengate 21c for Oracle database


1.   Get the DDL of source table and convert into PostgreSQL format to create required tables and indexes into Yugabyte database.

2.    create the source table definition files using Goldengate defgen utility.  

3.    create initialload extract params file and add extract process with “sourceistable” mentioned

4.    start the initial load extract. 



Target - 

YugabyteDB v2024.2.0.0

Goldengate 21c for PostgreSQL database

1.    Create the required tables and indexes structure into YugabyteDB

2.    Create the  checkpoint table 

3.    add replicate and start replicat process






Comments

Post a Comment

Popular posts from this blog

Seamless Data Replication from Oracle to YugabyteDB using Goldengate

Image
YugabyteDB  is a PostgreSQL-compatible, multi-master RDBMS that supports global data distribution, resilience, scalability, and enterprise features.  Customer can migrate, deploy, and run their applications with  YugabyteDB  across regions, clouds, and edges. In this blog, we will see how data can be replicated between  Oracle Database  and  YugabyteDB  using Oracle’s Goldengate classic.  Environment Setup :  At Source :  Create goldengate replication user c##ggadmin (common user in case of Container DB)  Grant required permission to goldengate extract user  Set/enable required parameter in database Install Oracle Goldengate for Oracle database Start Manager process Create defgen file for target database for the table having different definition Transfer defgen file to target server  Create Credentialstore and add credentials Configure Extract process Start extract  At Target :  Create goldengate user in tar...
Read more

Simplified Database migration from RDS PostgreSQL to YugabyteDB using voyager

Image
" YugabyteDB Voyager ”  is a migration tool from Yugabyte that powers you to perform offline/online migration with fall-forward and fall-back options from your on-premise/public cloud to YugabyteDB.  I have recently tested one of the scenario in my local environment, where source database is RDS PostgreSQL and target database is YugabyteDB which is running on ec2 cluster.  sharing step-by-step procedures which I have followed referring below document :  https://docs.yugabyte.com/preview/yugabyte-voyager/migrate/live-fall-back/ .  Step -1. Install yugabytedb voyager on intermediate server which have connectivity from/to source and target databases Step -2. Prepare Source and Target database for online migration Step -3. Run Voyager Assessment to validate the configuration Step -4. Run export schema from source database Step -5. Analyze the schema Step -6. Import the schema to target database Step -7. Export the data from source with snapshot and changes enabled ...
Read more