Heterogeneous Database Replication
Microsoft SQL Server 2005 supports the following heterogeneous scenarios for transactional and snapshot replication:
- Publishing data from Oracle to Microsoft SQL Server
- Publishing data from Microsoft 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 Microsoft 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.