From what you describe... I don't see any 'easy' way to do it. It is going to take a lot of work. The tables, their level of normalization, etc are not the problem. It's how your program interacts with data.
>Hello all.
>
>We got a request from one of our clients wanting to migrate from the native DBF tables to SQL2000 for security reasons. Their application is pure VFP6.0 using the native DBF only. It uses about 125 tables and about seventy five screens. The biggest table probably has about 3.5 million rows of data, not too big.
>
>What would be the "easiest" way to migrate to SQL2000, assuming that the tables are properly normalized and in good shape?
>
>thanks.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown