Skip to content

heterogeneous-database-replication.md

Latest commit

 

History

History
57 lines (41 loc) · 3.49 KB

heterogeneous-database-replication.md

File metadata and controls

57 lines (41 loc) · 3.49 KB
title Heterogeneous Database Replication
description Heterogeneous Database Replication
author MashaMSFT
ms.author mathoma
ms.date 09/25/2024
ms.service sql
ms.subservice replication
ms.topic conceptual
ms.custom
updatefrequency5
helpviewer_keywords
heterogeneous database replication, about heterogeneous database replication
replication [SQL Server], heterogeneous database replication
heterogeneous database replication

Heterogeneous Database Replication

[!INCLUDE SQL Server]

[!INCLUDEssNoVersion] supports the following heterogeneous scenarios for transactional and snapshot replication:

  • Publishing data from [!INCLUDEssNoVersion] to non-[!INCLUDEssNoVersion] Subscribers.

  • Publishing data to and from Oracle has the following restrictions:

Scenario 2016 or earlier 2017 or later
Replication from Oracle Only support Oracle 10g or earlier Only support Oracle 10g or earlier
Replication to Oracle All versions prior to Oracle 12c Not supported

Heterogeneous replication to non-SQL Server subscribers is deprecated. Oracle Publishing is deprecated. To move data, create solutions using change data capture and [!INCLUDEssIS].

Caution

[!INCLUDEssNoteDepFutureAvoid]

Publishing Data from Oracle

You can use [!INCLUDEssNoVersion] to publish data from Oracle with most of the same features and ease-of-use as [!INCLUDEssNoVersion] snapshot and transactional replication. This feature requires Oracle version 10G or earlier. Publishing data from Oracle is ideal for the following scenarios:

Scenario Description
[!INCLUDEmsCoName] .NET Framework application deployments Develop with [!INCLUDEmsCoName] Visual Studio and [!INCLUDEssNoVersion] while operating on data replicated from a non-[!INCLUDEssNoVersion] database.
Data warehousing staging servers Keep [!INCLUDEssNoVersion] staging databases synchronized with a non-[!INCLUDEssNoVersion] database.
Migration to [!INCLUDEssNoVersion] Test your application in real time against [!INCLUDEssNoVersion] while replicating the source system's changes. Switch to [!INCLUDEssNoVersion] when satisfied with the migration.

For more information, see Oracle Publishing Overview.

Publishing Data to Non-SQL Server Subscribers

The following non- [!INCLUDEssNoVersion] databases are supported as Subscribers to snapshot and transactional publications:

  • Oracle for all platforms that Oracle supports.

  • IBM Db2 for AS400, MVS, Unix, Linux, and Windows.

For more information, see Non-SQL Server Subscribers.