June 10, 2003 at 9:20 am
Can anoyone advise me: Is using a Linked Server the best way to replicate or duplicate data (i.e. insert, update) onto an SQL Server db and an Oracle 9i db simultaneously?
Or is there some other way of replicating from SQL Server to Oracle?
Thanks.
June 10, 2003 at 10:35 am
You can replicate to Oracle with no problems. And if you want to replicate all the inserts, updates and deletes made at sql Server, I would recommend transactional replication.
If you are new with replication you should read about it in BOL, and because yo are replicating to oracle you should used transformable replication using DTS within transactional replication.
You should be carefull about the fields in both servers, because they can get truncated.
And also, when generating the snapshot, you won't be able to generate it with native mode, because oracle, can't read it.
June 10, 2003 at 10:39 am
Thanks, I will certainly check out Transactional Replication.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply