Skip to content

heterogeneous-database-replication.md

Latest commit

 

History

History
54 lines (41 loc) · 3.27 KB

heterogeneous-database-replication.md

File metadata and controls

54 lines (41 loc) · 3.27 KB
title Heterogeneous Database Replication | Microsoft Docs
ms.custom
ms.date 03/14/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

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

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. 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.