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.
Publishing Data from Oracle
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.
Publishing Data to Non-SQL Server Subscribers
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.
Other Resources
Designing and Implementing (Replication)
Help and Information
Getting SQL Server 2008 Assistance