I looking for some suggestion on the best way to approach updating large amounts of data from VFP into SQL.
The project involves VFP constantly querying VFP tables looking for newly added or modified records (Based on date/time stamp) and then updating that record in a SQL table with a similiar structures. Currently, when VFP finds are records that needs to be updated, I am using SQLEXEC() to update SQL. It works fine, with the expection that it's slow. What I was thinking of doing is selecting all the records that need to be updated in SQL into a cursor, save it as an XML file and have SQL import it.
If there is someone out there that is doing something similiar, I would love to hear some additional Ideas or suggestions. I'm a beginner with SQL and may need some coaching, but I'm eager to learn
Thanks in advance.
HJ
The project involves VFP constantly querying VFP tables looking for newly added or modified records (Based on date/time stamp) and then updating that record in a SQL table with a similiar structures. Currently, when VFP finds are records that needs to be updated, I am using SQLEXEC() to update SQL. It works fine, with the expection that it's slow. What I was thinking of doing is selecting all the records that need to be updated in SQL into a cursor, save it as an XML file and have SQL import it.
If there is someone out there that is doing something similiar, I would love to hear some additional Ideas or suggestions. I'm a beginner with SQL and may need some coaching, but I'm eager to learn
Thanks in advance.
HJ