Skip to content

heterogeneous-database-replication.md

Latest commit

 

History

History
61 lines (46 loc) · 3.66 KB

heterogeneous-database-replication.md

File metadata and controls

61 lines (46 loc) · 3.66 KB
title Heterogeneous Database Replication | Microsoft Docs
ms.custom
ms.date 08/28/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
replication
ms.tgt_pltfrm
ms.topic article
helpviewer_keywords
heterogeneous database replication, about heterogeneous database replication
replication [SQL Server], heterogeneous database replication
heterogeneous database replication
ms.assetid 3fd983ad-e206-45db-9054-417c9b5bb815
caps.latest.revision 41
author BYHAM
ms.author rickbyh
manager jhubbard

Heterogeneous Database Replication

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

[!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:
    | |2016 or earlier |2017 or later | |-------|-------|--------| |Replication from Oracle |Only support Oracle 10g or earlier |Only support Oracle 10g or earlier | |Replication to Oracle |Up 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.