Bulk copy question

Hi,
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?

I need to copy the bulk data from the source table into a file on the
disk (of the ADO client and not on the disk of the SQL server) and then push
the data into the destination table. Is this possible at all through ADO? Or
do I need to use ODBC for this compulsorily?

Thanks in advance,
Madhu


.

Relevant Pages

  • Re: Execution Plan Hinting
    ... bulk insert field_values from '274.dat' with; ... ADO thing? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Grosse Datenmenge - XML Import in Datenbank
    ... Der XML Import in Access über ADO ist nicht wirklich empfehlenswert, ... Muss es XML sein? ... SQL Server bietet mit BULK INSERT ebenfalls ein Werkzeug für einen ...
    (microsoft.public.de.inetserver.iis.asp)
  • Re: How to Mimic Access Externally Linked Tables using ADO?
    ... > using SQL Server for efficiency reasons. ... > connection up programmatically using ADO or ADOX or some SQL Server API? ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... ADO does not have a query engine. ...
    (microsoft.public.data.ado)
  • Re: How to access the SQL server express from mfc application?
    ... There are different ways to do this via MFC. ... You could certainly try ADO, ... the entire contents of the database to a SQL Server Standard Server. ...
    (microsoft.public.vc.mfc)
  • Re: Generating one table with a terabyte of data
    ... Pretty much disabled the transaction log completely. ... We are using BULK INSERT ... for all those who don't know, SQL server prefers smaller BULK ... ORACLE seems to handle that 1 big file really well but with small files SQL ...
    (microsoft.public.sqlserver.dts)