... darkrealms ...

Forums before death by AOL, social media and spammers... "We can't have nice things"

comp.databases.ms-sqlserver

Notorious Rube Goldberg contraption

19,505 messages

[ << oldest | < older | list | newer > | newest >> ]

Message 18,415 of 19,505

Bob Barrows to Hardy

Re: how can I copy a huge table to anoth

27 Jul 11 14:27:57

   37a3c645   
   From: reb01501@NOyahooSPAM.com   
      
   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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)

[ << oldest | < older | list | newer > | newest >> ]