Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.