First I AM A NEWBIE! And as such I have absolutely NO idea what or how to do anything.
I have an application where we need to batch update from one table to another. We have remote sites which will upload their changes ( sometimes exceeding 10,000 records per site) and apply those changes to a central database table. I am trying to accomplish this using MM.Net.
The data, uploaded via FTP, is in VFP tables, and the central store is in SQL Server 2000. My questions are as follows (bear in mind you need some knowledge just to pose an intelligent question so mine is probably not intelligent)
- Do I load the VFP data into a DataReader/DataSet outside of the business object which represents the central store?
- What technique should I use to update from one to the other?
- What is the SQL syntax for this?
How do do I "scan thru" the VFP Data?There may be NEW records being uploaded as well, how do I write the INSERT statement.- I do not know how to reference a Datareader Object in a SQL statement ????? (DataReader - VFP Data)
- What would be the Syntax for the INSERT statement?
Thanks, I feel like I am floundering in un-charted waters.
Glenn