I am moving data from VFP til MS-SQL over a slow line. There are several ways to do this, so I would like to have your opinion on which is best/fastest.
a. I can select from the VFP table and in a loop do "If exists(..) insert.. else update.."
b. I can insert the table as is into a temporary sql server table and then use a SP to do a "if exists(..) insert from else update.. "
Since the line is slow I suppose the traffic between client and server will be reduced most using the last approach. But I have not tried. Which way is the best?
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