Home » Server Options » Replication » One way replication from MS sql server to Oracle 10g (Sql server 2005 windows 2003 32 bit and Oracle 10g 10.2.0.3 on linux 64 bit)
One way replication from MS sql server to Oracle 10g [message #442916] Thu, 11 February 2010 05:22 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,
Is it possible to replcate table data on real time from sql server (2005 32 bit or sql server 2000 32 bit)to oracle 10g running on linux 64 bit?

If yes then what are the steps.

It will be one way replication from sql server to oracle.

Which option is best sql server dts or Oracle Stream replication

to replicate table data.

Regards,
Re: One way replication from MS sql server to Oracle 10g [message #442917 is a reply to message #442916] Thu, 11 February 2010 05:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think Streams works from SQL Server to Oracle but ony for the opposite way.

Regards
Michel
Re: One way replication from MS sql server to Oracle 10g [message #442923 is a reply to message #442917] Thu, 11 February 2010 06:49 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Any options to replicate sql server 32 bit tables to oracle 10g 64 bit.
What should be the steps

Re: One way replication from MS sql server to Oracle 10g [message #442928 is a reply to message #442923] Thu, 11 February 2010 07:04 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think for this way you have to ask this on SQL Server forum.

Regards
Michel
Previous Topic: MV referesh error
Next Topic: refresh mv using oracle jobs everyday except for sunday @ 6 AM
Goto Forum:
  


Current Time: Thu Mar 28 09:45:38 CDT 2024