Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vksgnu
Starting Member
1 Post |
 Posted - 2005-06-18 : 07:49:42
|
| Hi,I was trying to get Oracle data on Sql Server database using 3rd party tool. One option I came across:daffodil replicator (open source)http://www.daffodildb.com/replicator/index.htmldoes anybody had a chance to use it and would like to share experience. also if someone could advice any other option available.thanks in advance! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-18 : 08:09:41
|
| I've heard of Daffodil, but not that particular product.Depending on your situation, Data Transformation Services could push data between SQL Server and Oracle, but it can't be called replication. DTS would be appropriate if you have to import new data from one system to another, i.e. refreshing a data warehouse. Anything requiring more interaction would not work well with DTS, at least not without a lot of programming.Can you provide more information on your scenario and requirements? |
 |
|
|
|
|
|
Sql Server to Oracle replication