>I have a medium sized application written in VFP 6.0. There are approximately 45 free tables, 100 forms, 40 reports, and 100 programs. The app was converted from FoxPro. The core was rewritten when moved to VFP but the fringe forms were simple converted from FoxPro to VFP. Anyway the app is a hodge podge. It is installed at about 30 sites and each site has about 5 clients who each access it over the Novell network.
>
>Now my baby, and I, need to grow up. My company wants to move from 30 sites to a single site with a centralized database. Currently the response time on my application is too slow to allow all my clients (which are in FL, GA, TN, VA) to access a single copy of my application. My company is also throwing out buzz words like Sybase, SQLServer, Unix - but nothing is offical.
>
>I am at a lose as to what to even start researching. Intranet, Client/Server, whatever. Where should I start looking for answers?
>
>Thanks
>
>Brenda

My tests of having users execute EXEs via a T1 line to a central server showed such a method to be too slow to be of value, especially with 5 to 15 users are trying to bang away. Mark's idea, along with XML could be a way to go in your situtation.

What we are doing here is using Oracle on the server and accessing and updating the data via web browsers running our java packages. Most of the database work is done on the Oracle server side using triggers and packages. We use PLSQL Developer on the Oracle side (http://www.allroundautomations.nl/plsqldev.html ($150/seat or 20 seats/$1K)and for the browser end we were using JDeveoper, but it is too expensive. So, we are using cheap editors like Brief, or the one with TurboC++ (one guy is using Notepad!) and using the javac compiler on the command line to compile the Java packages.