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