How to import bulk data

Hi friends,
How can I import data from remote database. My local DB is Sql
Server 2005 and remote DB is Oracle. The data to be imported is very
large data(in GB).
How can I import faster? The table structures in both the DBs are
same.
Can you give a clear idea.
Thanks in advanceHi,
You can use SSIS. In Management Studio, right click your source database
and choose "Tasks > Import Data..." Then for your data source choose OLE DB
for Oracle. Fill in all the blanks in the Wizard and check "Save SSIS
Package" at the end if you want to run it more than once.
One thing to watch out for transferring Oracle to SQL Server. I was
transferring a table with a couple hundred rows on a daily basis over a WAN
VPN, and it would take about 45 minutes. I finally figured out why it was
so friggin' slow. There were three or four Oracle columns defined as
VARCHAR2(4000). Even though each one has only 3 to 8 characters of data,
they were getting padded out to 4000 characters. That was about 2.4 GB of
padding. I got the Oracle DBA to redefine them to VARCHAR2(10), and my
transfers dropped to 4 1/2 min!
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
<rajkm42@.googlemail.com> wrote in message
news:1190061613.152877.107680@.o80g2000hse.googlegroups.com...
> Hi friends,
> How can I import data from remote database. My local DB is Sql
> Server 2005 and remote DB is Oracle. The data to be imported is very
> large data(in GB).
> How can I import faster? The table structures in both the DBs are
> same.
> Can you give a clear idea.
> Thanks in advance
>