export table from one database to another on different server

i've one dev and one prod, one of the table in dev database having 70
millions records and need to export to one of the table in prod
database. both machine got 2 nic, one 10/100 mbps and the other 1gbps
speed. databases on raid5.
the transmission between two servers is very slow, it's transmitting
1000 rows per 4 secs. sql 2000 with sp3 on both machines, i'm using
dts. please advice to speed up.

thanks,
PatA fast way to transfer data between 2 SQL Servers is via DTS. You can
specify the 'fast 'load' and 'table lock options to maximize performance
if the target table has no indexes. Also, run the package directly on
the source or destination server rather than an intermediate box.

--
Hope this helps.

Dan Guzman
SQL Server MVP

--------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index...epartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--------

"Pat" <murali_12180@.yahoo.com> wrote in message
news:2a1ff510.0309120503.149eccd4@.posting.google.c om...
> i've one dev and one prod, one of the table in dev database having 70
> millions records and need to export to one of the table in prod
> database. both machine got 2 nic, one 10/100 mbps and the other 1gbps
> speed. databases on raid5.
> the transmission between two servers is very slow, it's transmitting
> 1000 rows per 4 secs. sql 2000 with sp3 on both machines, i'm using
> dts. please advice to speed up.
> thanks,
> Pat