I suggest that you import the vfp table into the sql server and then use simple sql to make sure that the old sql server table has all the data from the vfp table you imported.

BTW, The limit for the size of a batch job is 65536 * network packet size (default of 4096 bytes), which is 256 MB. If you wanted to use xml your going to probably have to break it up.

>I am trying to make some managers nerves a bit less frazled. What has happend is that we are migrating from VFP to SQL server. Initially we used the DTS to transform the VFP table to a SQL table. However, the two table were maintained at the same time with the older VFP data import routine working fine for the VFP table but the SQL table was only added to by manually adding in chuncks of data. Now there is concern that some data has been missed so I have to go from the top of the VFP table and verify that the data is present in the SQL table (and then make them the same). I have a routine the checks one record at a time but I was trying to find the most efficient and fastest way of completing this job. Sending one record at a time is fast but it seemed to be innefficient in regards to network traffic.
>
>Kelly