Re: Bulk copy question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

> 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


.

Relevant Pages

  • Re: Migrating from DAO to ADO
    ... I am currently involved in migrating our backend DB from Acess to SQL ... the front end will reside in MS Access. ... much of the code uses DAO references. ... Do you realise that DAO can speak quite happily to SQL Server databases via ...
    (microsoft.public.vb.general.discussion)
  • Re: Procmail Regex
    ... Right now I have a global account which reside in my ISP's server, ... I twice a day get all my emails using fetchmail + cron and delivered ...
    (Fedora)
  • Re: Secured db now events failing
    ... The MDW would reside on the server, and as Joan alrealy said, the ... Microsoft Access MVP ... tell me where the MDW would reside and where the source MDB would reside. ...
    (microsoft.public.access.security)
  • RE: Hit Counters
    ... > a hit counter so that it does not go back to 1 every time and also continues ... Make the desired changes there. ... They reside on the ... server, not the files on your computer's hard drive. ...
    (microsoft.public.frontpage.client)
  • Re: Procmail Regex
    ... Right now I have a global account which reside in my ISP's server, ... I twice a day get all my emails using fetchmail + cron and delivered ...
    (Fedora)