Re: copying large SQL SERVER tables between DB's

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 08/30/04

Next message: Jim Moon: "DB Maintenance & Single-User Mode"
Previous message: Aaron [SQL Server MVP]: "Re: Stored procedure modification date?"
In reply to: Avi Perez: "copying large SQL SERVER tables between DB's"
Messages sorted by: [ date ] [ thread ]

Date: Mon, 30 Aug 2004 17:15:08 -0400

Take a look at BCP and BULK INSERT in BooksOnLine. The native mode will
probably give fastest and cleanest results.

-- 
Andrew J. Kelly  SQL MVP
"Avi Perez" <avi.perez@irisbi.com> wrote in message
news:e7sHr%23rjEHA.3972@tk2msftngp13.phx.gbl...
> Hi
>
> I have a simple question... how does one copy a LARGE table (say 100m
rows)
> from one database to another in SQL Server 2000?
>
> Using the copy table feature in DTS is great - but can it be done from a
> T-SQL interface (say a stored procedure or something)?
>
> the bulk insert/copy features seem to only work with data transfers
between
> a DB and an external data file.
>
> Any external software?
>
> thanks
>
> avi
>
>

Next message: Jim Moon: "DB Maintenance & Single-User Mode"
Previous message: Aaron [SQL Server MVP]: "Re: Stored procedure modification date?"
In reply to: Avi Perez: "copying large SQL SERVER tables between DB's"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Database roles
... Andrew J. Kelly SQL MVP ... > Is the only option to maybe create the table that you need to bulk insert ... >> Andrew J. Kelly SQL MVP ... >>>> You mention a dbo table but the error suggests it is not dbo. ...
(microsoft.public.sqlserver.security)
Re: Database roles
... The current user is not the database or object owner of table ... Is the only option to maybe create the table that you need to bulk insert to ... > Andrew J. Kelly SQL MVP ...
(microsoft.public.sqlserver.security)