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