Re: Bulk copy question
- From: "Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom>
- Date: Fri, 11 Nov 2005 13:38:12 -0000
> I want to bulk copy data from a SQL server 2000 (or above) table to
> another table (on another server instance possibly). Can I use ADO to do
the
> same?
There is no Bulk Copy in ADO. There is DTS
But the question above can be split into 2.
If the 2 tables reside on the same Server (and possibly in different
databases), a straight SQL command will do that
INSERT INTO table2 SELECT * FROM [database.dbo.]table1
If the 2 tables reside on different servers, you need 2 connections and be
reading records from one, writing to the other.
Stephen Howe
.
- Follow-Ups:
- Re: Bulk copy question
- From: Joe Mamma
- Re: Bulk copy question
- References:
- Bulk copy question
- From: Madhu Gopinathan
- Bulk copy question
- Prev by Date: Re: Unable to open Excel file in read-only if file already open by another user
- Next by Date: OT: Pregunta sobre localhost loopback
- Previous by thread: Bulk copy question
- Next by thread: Re: Bulk copy question
- Index(es):
Relevant Pages
|