Hi all,

I need to update records in a sql table based on records in an oracle table.

The update needs to be done where OracleTable.C_Ref = SqlTable.C_Ref. I am
unable to get the databases linked and there are 14 million records in the
oracle table and 200,000 records in the sql table. Can someone advise of the

OK so you have a couple of ways


You can TXFR the rows from Oracle to a SQL Server staging table and then
do a TSQL update. Although there are 14 million rows in the Oracle
table have they all been updated or are new? If not then a WHERE Clause
would restrict them and cut dwn on bandwidth.

You can also, and this is probably more preferable, use a linked server.
This will allow you to query the Oracle DB as though it was local
(almost).

Use a DDQ. This is row*row based and in my opition no better than #1

--


----------------------------------------
Allan Mitchell (Microsoft SQL Server MVP)
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com





[quoted text, click to view]