Skip to content

non-sql-server-publishers.md

Latest commit

 

History

History
56 lines (43 loc) · 3.48 KB

non-sql-server-publishers.md

File metadata and controls

56 lines (43 loc) · 3.48 KB
title Non-SQL Server Publishers | Microsoft Docs
ms.custom
ms.date 08/29/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
replication
ms.tgt_pltfrm
ms.topic article
helpviewer_keywords
heterogeneous database replication, non-SQL Server Publishers
non-SQL Server Publishers
heterogeneous data sources, non-SQL Server Publishers
Publishers [SQL Server replication], Oracle
ms.assetid 08a160a6-33be-46b5-bc7b-d53180d8bdf1
caps.latest.revision 31
author BYHAM
ms.author rickbyh
manager jhubbard

Non-SQL Server Publishers

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

Publishing data from non-[!INCLUDEssNoVersion] sources allows you to consolidate data in [!INCLUDEmsCoName] [!INCLUDEssNoVersion]. [!INCLUDEssNoVersion] can subscribe to snapshot or transactional data published from an Oracle database. For more information about publishing from Oracle, see Oracle Publishing Overview.

[!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 from non-[!INCLUDEssNoVersion] databases 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.

See Also

Heterogeneous Database Replication