>>Maybe not, but this is for a conversion from VFP to SQLServer. There will only be one user while this is running.
>
>One rule:
>NEVER! NEVER!!!!!! NEVER!!!!!!!!!!!!!!!!!
>Program with assumption for a single user, esp. for SQL Server.
The assumption is that you start with blank db on the server, and fill it from the dbfs. Nobody uses the app at the time, or else you don't do it at all. Such a conversion can be done only during downtime. Unless there's some complicated scheme to have timestamps on all records of all dbfs, and then pass any updates from dbfs to the SQL db - but then you can count on it being a mess and on having problems.
It's a xor situation, IMO - either you're alone with both sets of data, or you just don't do it. Anything else is just a challenge to Murphy.