How to transfer data from sql server2005 to Oracle

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

How to transfer data from sql server2005 to Oracle

Author

Topic

komnaz
Starting Member

5 Posts

Posted - 2008-12-20 : 04:08:43

Hi,

I have to trasfer data from sql server2005 to Oracle 10g. Sql server2005 is in windows plateform while Oracle10g in Unix plateform.
data will transfer on regular basis i mean whatever changes occurs in sql server it will automatically updated in oracle10g.

Please reply me what action we will have to take.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-12-20 : 07:20:49

Do you have a linked server set up on the SQL box pointing to the Oracle server?

--
Gail Shaw
SQL Server MVP

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-20 : 08:50:08

quote:
Originally posted by komnaz

Hi,

I have to trasfer data from sql server2005 to Oracle 10g. Sql server2005 is in windows plateform while Oracle10g in Unix plateform.
data will transfer on regular basis i mean whatever changes occurs in sql server it will automatically updated in oracle10g.

Please reply me what action we will have to take.

Look at Transactional Replication from Sql server to Oracle 10g in Booksonline.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources