Welcome  |  Sign in
Skip Navigation Links
SQL Server Developer Center
Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Replication
Development
Other versions are also available for the following:
SQL Server 2008 Books Online
Heterogeneous Database Replication

SQL Server 2008 supports the following heterogeneous scenarios for transactional and snapshot replication:

  • Publishing data from Oracle to SQL Server.
  • Publishing data from SQL Server to non-SQL Server Subscribers.

You can use SQL Server to publish data from Oracle with most of the same features and ease-of-use as SQL Server snapshot and transactional replication. Publishing data from Oracle 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.

For more information, see Oracle Publishing Overview.

The following non-SQL Server 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.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker