|
Home > Archive > MS SQL Server > February 2006 > Transfer data sql2k
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Transfer data sql2k
|
|
|
| Hi,
I have 200 mil records in one table need to be transferred from one server
to another server fro test.What is the best way to do the transfer by
passing the log?
Select into?
Thanks,
| |
| Sreejith G 2006-02-28, 8:23 pm |
| Try, BULK INSERT in batches...
http://msdn.microsoft.com/library/d...tun_1a_6b39.asp
bypassing the log? i dint get what you exactly want from this. For not to
create huge log's load it in batches.
Thanks,
Sree
"mecn" wrote:
> Hi,
> I have 200 mil records in one table need to be transferred from one server
> to another server fro test.What is the best way to do the transfer by
> passing the log?
>
> Select into?
>
>
> Thanks,
>
>
>
|
|
|
|
|