>Hi all
>
>We have an application using about 600 tables in a VFP6 database, our app for the most part is not using views of the tables to access data but tables in the DE.
>
>So by all meen, SQL upsizing wizard will not work in our case. Our application pretty large (400 forms, 100 Progs, reports, etc..) It will take a lot of work to convert all manually. We fist developped this app converting Fox 2.X App and choose this approach to avoid full rewrite of the biggest prgs (with no user interface)
>
>All the table update functions are handled by one class and we are use private data session (5).
>
>Basicly, i need some suggestions on what would be the best approach to start converting this app into an SQL Enabled app without have to rewrite everything.
>
I agree with Edward. Bulding a C/S app is not as simple as connecting your program to the remote source, it requires a different application philosophy that most 2.6 apps never subscribed to.
The VFP docs detail a lot of what is involved, so get to reading. I wouldn't count on any magical shortcuts though.
Erik Moore
Clientelligence