April 2020

Apr 23 2020

Replication between SQL Server 2012 CDC and Oracle 12c using GoldenGate 19c

In this post I will walk you trough the steps to configure Oracle GoldeGate 19 to replicate transactions between Microsoft SQL Server 2012 using CDC Capture replication and Oracle 12c. We are going to build a simple unidirectional replication of the table ORG.DEPT between two heterogeneous databases. The below diagram shows the GoldenGate architecture of a replication unidirectional from SQL Server database to Oracle database. Operating System Database Database Name GoldenGate version Oracle GoldenGateHome GoldenGate installer IP Database Server Manager Read More

By • Databases, Golden Gate, Oracle, Replication, SQL Server • 0

Apr 21 2020

Install Oracle GoldenGate 12c for PostgresSQL 12.2 in AWS EC2 RHEL 8

In this post I will install GoldenGate 12c for PostgreSQL 12.2 in AWS EC2 in Red Hat Linux 8. I going to install Oracle GoldenGate 12c with the below specifications: Operating System: Red Hat Enterprise Linux release 8.0 (Ootpa) Database: Postgress 12.2 GoldenGate version: 12.2.0.2.2 GoldeGate installer: 122022_ggs_Linux_x64_PostgreSQL_64bit.zip 1. Create the GoldenGate Home directory and setup the environment variable ($GGH) 2. Download Oracle GoldenGate 10.1.0.0.4 for Oracle (64 bits) 122022_ggs_Linux_x64_PostgreSQL_64bit.zip from Oracle website. 3. Transfer the zip file 122022_ggs_Linux_x64_PostgreSQL_64bit.zip to Read More

By • Amazon Web Services (AWS), Cloud, Databases, PostgreSQL, Replication • 0

Apr 18 2020

Install Oracle Goldengate 19c for Oracle Linux.

In this post I will install GoldenGate 19c for Oracle 12c in Linux 7.1, this will be the start point for the next post that replicate data from SQL Server 2012 to Oracle 12c. I going to install Oracle GoldenGate in the below environment: Operating System: Oracle Linux Server 7.1 Database: Oracle 12c (12.1.0.2.0) GoldenGate version: 19.1.0.0.4 GoldenGate installer: 191004_fbo_ggs_Linux_x64_shiphome.zip 1. Download Oracle GoldenGate 10.1.0.0.4 for Oracle (64 bits) 191004_fbo_ggs_Linux_x64_shiphome.zip from Oracle website. 2. Transfer the zip 91004_fbo_ggs_Linux_x64_shiphome.zip to a Read More

By • Databases, Oracle, Replication • 0

Apr 16 2020

Install SQL Server 2012 Service Pack 4

In this post I will show install SQL Server 2012 Service Pack 4. 1.Check the current version of SQL Server 2012, the below query returned the value RTM (release to manufacturing ) means that is the first release of SQL 2012 without applying any Service Pack. 2. Download the Service Pack 4 SQLServer2012SP4-KB4018073-x64-ENU.exe from Microsoft Download Center 3. Run the installer of SP 4 SQLServer2012SP4-KB4018073-x64-ENU.exe (Run as Administrator) a. Check the Installer pass all validations. Click on “Show details” button Read More

By • Databases, Patches, SQL Server, Upgrade • 0

Apr 15 2020

Install Oracle Goldengate 19c for Microsoft SQL Server.

In this post I will guide you trough the steps to install and configure Goldengate 19c for Microsoft SQL Server 2012, this will be the start point for the next post that replicate data from SQL Server 2012 to Oracle 12c. I going to install Oracle GoldenGate in the below environment: Operating System: Windows 7 Professional Database: SQL Server 2012 Enterprise Edition GoldenGate version: 19.1.0.0.3 GoldenGate installer: 191003_ggs_Windows_x64_MSSQL_64bit_CDC.zip. 1. Prerequiste According to Oracle documentation using the Microsoft SQL Server Native Read More

By • Databases, Replication, SQL Server • 0