1. Home
  2. Knowledge Base
  3. GoldenGate
  4. Oracle GoldenGate Cloud Service for MS SQL Server
  1. Home
  2. Knowledge Base
  3. Oracle Cloud
  4. Oracle GoldenGate Cloud Service for MS SQL Server

Oracle GoldenGate Cloud Service for MS SQL Server

In March earlier this year Oracle announced Oracle GoldenGate Cloud Service support for more than 40 source and target technologies including Snowflake, MongoDB, Microsoft SQL Server, Azure SQL Database, Oracle Autonomous JSON Database, Oracle NoSQL, Azure Cosmos DB for MongoDB among others.

https://blogs.oracle.com/dataintegration/post/oci-goldengate-adds-support-for-snowflake-mongodb-microsoft-sql-server-azure-sql-database-oracle-autonomous-json-database-oracle-nosql-azure-cosmos-db-for-mongodb-and-more

In this example, we will see how to create a deployment for Microsoft SQL Server using the newly released Oracle GoldenGate Cloud Service version 21.9.

A deployment is where we create and manage Oracle Cloud Infrastructure GoldenGate resources like Extracts and Replicats via a deployment console – as well as through the command line Admin Client.

In the Console navigation menu, click Oracle Database, and then select GoldenGate. On the Deployments page, click Create deployment.

From the Select a technology drop down list we pick the option Microsoft SQL Server.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Provide the GoldenGate instance name along with the administrator username and password – note we will use this account to login both via the deployment console as well as the command line.

Click Create

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Wait for the status of the deployment to change from Creating to Active

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

The following screen shots shows how the command line Admin Client is launched and how to connect to the GoldenGate Cloud Service deployment using the command line Admin Client.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

From the Deployment Details page in the OCI console, we can obtain the console URL and then connect to the deployment by providing the GoldenGate administrator account and password.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Create the SQL Server login, database, user and enable CDC in the database.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

From the GoldenGate menu in OCI console click on Connections.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Click on Create connection.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Provide a name for the connection and then from the Select a connection type drop down list we pick the option Microsoft SQL Server.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Here we provide details of the SQL Server database – either provide the FQDN or IP address of the SQL Server instance host along with the database name, SQL Server port number as well as the user credentials to connect to the database name provided.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Click on Create and wait till the status of the connection changes from Creating to Active.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

After the connection is created and is active, we assign a deployment to the connection. Since the connection is a Microsoft SQL Server connection, the deployment also needs to be a valid Microsoft SQL Server deployment.

Click on the Assign Deployment button.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

After the connection has been created and the active connection is assigned to a deployment, if we connect to the deployment console, we can see the connection has created a GoldenGate credential as shown below.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Update the GGSCHEMA parameter in the GLOBALS file.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Click on the icon to connect to the SQL Server database and test that the connection is working fine.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

Oracle Zero Downtime Migration (ZDM) is the free-to-use Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracle Cloud Infrastructure.

ZDM provides a number of migration options – Physical offline,Physical online, Logical offline, Logical online.

In a Logical Online migration, users are still connected to a live database while ZDM is executing in the background. Internally ZDM uses Oracle GoldenGate technology to enable the ‘zero-downtime’ migration as well as Oracle Data Pump.

These series of posts provide a step-by-step procedure of how to do an Online Logical Migration of an Oracle Database 12c to Oracle Database 21c.

In this example both the source 12c and target 21c databases are hosted in OCI – but the same procedure can easily be adopted to migrate (and upgrade) an on-premises Oracle database to OCI.

In the next post, we will see how to ADD TRANDATA, Create the Extract as well as the Distribution Path. Watch this space!

Updated on May 5, 2023

Was this article helpful?

Related Articles

Leave a Comment