Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Non-SQL Server Publishers

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Publishing data from non-SQL Server sources allows you to consolidate data in Microsoft SQL Server. SQL Server can subscribe to snapshot or transactional data published from an Oracle database. For more information about publishing from Oracle, see Oracle Publishing Overview.

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

Caution note Caution

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Publishing from non-SQL Server databases is ideal for the following scenarios:

Scenario

Description

Microsoft .NET Framework application deployments

Develop with Microsoft Visual Studio and SQL Server while operating on data replicated from a non-SQL Server database.

Data warehousing staging servers

Keep SQL Server staging databases synchronized with a non-SQL Server database.

Migration to SQL Server

Test your application in real time against SQL Server while replicating the source system's changes. Switch to SQL Server when satisfied with the migration.

Community Additions

ADD
Show:
© 2015 Microsoft