Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From: "Bob Barrows" <reb01501@NOyahooSPAM.com>
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: how can I copy a huge table to another database?
Date: Wed, 27 Jul 2011 14:27:57 -0400
Organization: A noiseless patient Spider
Lines: 15
Message-ID: <j0plbi$6ss$1@dont-email.me>
References: <84557c50-c2f4-43e7-bd33-3972e14ac737@g5g2000prn.googlegroups.com>
Injection-Date: Wed, 27 Jul 2011 18:28:02 +0000 (UTC)
Injection-Info: mx04.eternal-september.org; posting-host="NUmboHSNYG4cX5Ys9j8TNw"; logging-data="7068"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1/bLJiyHqJDxMThMg/KHHMVWjTfQmqDiXw="
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.2001
X-Antivirus-Status: Clean
X-Newsreader: Microsoft Outlook Express 6.00.2800.2001
X-Antivirus: avast! (VPS 110727-0, 07/27/2011), Outbound message
Cancel-Lock: sha1:QKR1f2ZJzoLvB2uk5btIJTFtrfk=
X-Priority: 3
X-MSMail-Priority: Normal
Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:574

Hardy wrote:
> suppose I have 100M records and we don't like INSERT.
>
> one option is to export to external file and bulk load the file.
>
> is there any better idea? linked server configured here.
>
> Thanks.
What version of sql server?

There's always bcp, dts, ssis.
Depending on the version, a dts or ssis package can be generated using the
Import/Export wizard.