GoldenGate 12.1.2 Replication from SQL Server to Oracle

This is a post using GoldenGate 12.1.2 from a SQL Server source database to an Oracle 11gR2 database.

What this tutorial will cover:

1. OGG installation on Windows
2. OGG installation on Linux using the graphical installer
3. Direct Load method to initially copy the data from SQL Server to Oracle
4. Configuration of the normal live replication from source to target

This tutorial does not cover the installation of SQL Server 2008R2, but does show the pre-requites for using OGG with SQL Server as well as the certification matrix of OGG 12.1.2 .

I’ve included lots of screenshots for the install to hopefully make things a bit easier to follow. You can download it from here .

Good Luck!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s