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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only