Groups > comp.databases.ms-sqlserver > #574

Re: how can I copy a huge table to another database?

From	"Bob Barrows" <reb01501@NOyahooSPAM.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: how can I copy a huge table to another database?
Date	2011-07-27 14:27 -0400
Organization	A noiseless patient Spider
Message-ID	<j0plbi$6ss$1@dont-email.me> (permalink)
References	<84557c50-c2f4-43e7-bd33-3972e14ac737@g5g2000prn.googlegroups.com>

Show all headers | View raw

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.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

how can I copy a huge table to another database? Hardy <wyhang@gmail.com> - 2011-07-27 08:57 -0700
  Re: how can I copy a huge table to another database? "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-07-27 14:27 -0400
  Re: how can I copy a huge table to another database? "Fred." <ghrno-google@yahoo.com> - 2011-07-27 13:45 -0700
  Re: how can I copy a huge table to another database? Erland Sommarskog <esquel@sommarskog.se> - 2011-07-27 23:53 +0200

csiph-web