I have developed an application using VFP 6 and with VFP database. The program is using traditional command like USE, APPEND, RLOCK, REPLACE, SKIP, GO TOP, ROLLBAK etc instead of using SQL command.
If I want to migrate to MS SQL server
1. What should I do to the database? (e.g remote data, views etc)
2. Must the programs changes of re-code.
3. Is there any tools that will speed-up the processDid you use local views for data access in your VFP6 application? If you did then the conversion may be very easy as you can just use remote views. Or if you segregated all of your data access commands in their own logical tier then again the conversion to use SQL*Server might be fairly straight-forward.
I guess the answer is -- it depends! If you directly accessed VFP tables then it might be a re-write to get it to work. In that case an investigation of a commercial framework might be the best course of action.
Kevin