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
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 DBA_JAF • Databases, Golden Gate, Oracle, Replication, SQL Server • 0