Re: Bulk copy question

> 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: 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: one exchange for multiple domains?
    ... they would just reside in a different domain. ... You can have your exchnage server installed in any domain in a forest and ... have it host users from multiple domains within the forest. ... Why would you want to install it in a root domain? ...
    (microsoft.public.exchange2000.general)
  • 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)