I need to copy data from vfp-tables to a sql2000-server. I now use ADO to connect to the sqlserver, to remove data first and then to upload it. I´m surprised by the speed this all takes place. When uploading >50000 records it takes forever. I´m sure this can be done a lot better.
My questions are: how can I upload data with the greatest speed? Is ADO the way to do it. Should I and can I use BCP? If so, how?
Suggestions are appreciated.
Ron
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement