Large Database

#1

I have an Oracle table which has about 30 millions rows on it. I have a SQL
table which has about 20 thousand rows on it. I want to pull from the Oracle
table the corresponding rows from the SQL table. Would I use DTS for this?
Is there a way for me to join the information from these two tables or an I
forced to bring down all 30 million rows from the oracle table and then load
them into a SQL table and then do my join at that time? Sounds like a awful
lot of processing. ANy ideas of how this might be structured?

#2

You do not have to pull all rows to SQL Server

Have a look at Linked Servers

"Jim Heavey" <JimHeavey (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have an Oracle table which has about 30 millions rows on it. I have a
SQL
table which has about 20 thousand rows on it. I want to pull from the
Oracle
table the corresponding rows from the SQL table. Would I use DTS for
this?
Is there a way for me to join the information from these two tables or an
I
forced to bring down all 30 million rows from the oracle table and then
load
them into a SQL table and then do my join at that time? Sounds like a
awful
lot of processing. ANy ideas of how this might be structured?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Large Database

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Large Database - 02-10-2005 , 05:29 PM

Re: Large Database - 02-11-2005 , 06:22 AM