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
 General SQL Server Forums
 New to SQL Server Programming
 Insert data into Oracle from SQLSERVER

Author  Topic 

sg_karthi
Starting Member

1 Post

Posted - 2010-06-16 : 22:26:09
Hello Everybody,

I'm newbie to SQLSERVER.
I would like to know whether the below scenario is possible, if so how?

1. I have a table in SQLSERVER and same table name in ORACLE also.
2. If I insert / update / delete in SQLSERVER table, it should replicate into ORACLE table.
3. I guess, some trigger should be written in SQLSERVER and to have connection with ORACLE table.

How to achieve about points ?
Thank you.

-Karthik

rajayan2000
Starting Member

2 Posts

Posted - 2010-06-17 : 00:38:09
You can use SQL SERVER DTS - Import/Export wizard for transferring data from SQL server to Oracle.
Go to Top of Page
   

- Advertisement -