insert into oracle table from mssql server table
-
Hi guys, how do I insert into an oracle database table with a select statement from within mssql server2005 or 2000? e.g Oracle db: Table A id,msisdn,message Msql server:Table A id, msisdn, message. 1 +476334566 Happy birhday So I want to select this result from sql server database and insert into oracle Table A. Thanks for you solutions.
-
Hi guys, how do I insert into an oracle database table with a select statement from within mssql server2005 or 2000? e.g Oracle db: Table A id,msisdn,message Msql server:Table A id, msisdn, message. 1 +476334566 Happy birhday So I want to select this result from sql server database and insert into oracle Table A. Thanks for you solutions.
Nasty You need to set up a linked server from SQL to Oracle, this will give you access to the table. This is a particularly nasty thing to have to do, the server name will then be hard coded into your procedure and will require modification when you promote the proc from dev/uat to production. (and I hate linked servers and I hate setting up Oracle and....) Good Luck.
Never underestimate the power of human stupidity RAH