Question How to select from oracle and insert into Ms SQL within the single statement?

[raysefo]

Hi,

I have a statement like this;

insert destinationtable(col1,col2,col3)
select col,col2,col3
from sourcetable t1
where not exists(select * from destinationtable t2 where t1.col1 = t2.col1)

I would like to insert into destinationtable which is MS SQL and the sourcetable is Oracle. Is there a way to do this?

Thanks in advance.



Best Regards.

 

[cjard]

only if you can get oracle and sqls to connect directly to each other. Maybe sqls can make an odbc conn to an oracle, as though it were a client..