Re: ADO - Copy Data from one data source to another via VB6

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 08:16:07 -0700

Yes, you can write BCP or DTS routines using SQL-DMO from VB6. It would move
the data far faster than ADO. 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"rmsterling" <rmsterling@avaya.com> wrote in message 
news:F8E2F464-F681-4143-9FAE-4FAA00A5C2B0@microsoft.com...
> Re: ADO - Copy Data from one data source to another via VB6
>
> I have two data sources located on two different servers.
> Both data sources are defined as a System DSN in the ODBC Administrator.
>
> Currently I open both sources using ADO and copy the records from one 
> source
> to another. As there are thousands of records it takes hours to copy the 
> data.
>
> I noticed if both sources are SQL Server I can use DTS services. The 
> problem
> with this is that the SQL query is fixed. I need to be able to alter it 
> from
> VB6.
>
> Does anyone have any VB6 code that does this using a OLE plug-in?
> OR
> Does anyone know any other way of performing this task quicker than the 
> way
> I am doing it above?
>
> Please post answers to MSDN Newsgroup thread and to my email address 
> below.
>
> Many thanks in advance.
>
> -- 
> ----------------------------
> Regards,
> Richard Sterling
> Senior Software Engineer Tel : +44 (0)1707 392200 ext 4815
> Avaya ECS Ltd, United Kingdom
> mailto:rmsterling@avaya.com
>

Relevant Pages