I am rewriting an application that existed in Foxpro earlier. As a part of this rewrite we also need to migrate all the data from Foxpro to SQL server.
We have built a .NET application for data migration. The application reads data from Foxpro (.dbc file), transforms it, and then load to a SQL server table. We are using VFPOLEDB provider. The process works fine for most of the data. But for some data the extract process does not load all the rows from Foxpro. I cannot see a valid reason for this behavior. For instance if I go to Visual Foxpro and run a sql query it returns me more rows than when I run the same query with OLEDB provider. Why is this difference? I would highly appreciate if someone can provide some insight into it.
