Saved Bookmarks
| 1. |
Is It Possible To Replicate Data From Sql Server To Oracle? |
|
Answer» Yes this can be done using heterogeneous replication. In SQL Server 2000, publishing data to other databases such as DB2 or Oracle was SUPPORTED; however, publishing data from other databases was not supported without custom programming. In SQL Server 2005 and later versions, Oracle databases can be directly replicated to SQL Server in MUCH the same WAY as standard SQL Server replication. For more INFORMATION, please read tip: Introduction to SQL Server Heterogeneous Replication. Yes this can be done using heterogeneous replication. In SQL Server 2000, publishing data to other databases such as DB2 or Oracle was supported; however, publishing data from other databases was not supported without custom programming. In SQL Server 2005 and later versions, Oracle databases can be directly replicated to SQL Server in much the same way as standard SQL Server replication. For more information, please read tip: Introduction to SQL Server Heterogeneous Replication. |
|