>Greetings to all,
>
>I have been given the green light to proceed with building a modern version of our FPD2.6 business software and I would like to weigh your opinions and input before going too far.
>
>This will be a very full featured application encompassing receiving, barcode inventory, storage, dispatch/scheduling, pickup/delivery, work orders, invoicing, statements...Reports via print, email, fax. I want to have a barebones program running in six weeks (receiving, inventory, pickup/delivery, and invoicing). I am the only developer on the project and it is in house. I will be able to use the existing computational code and data structures for the most part.
>
>It will be built in VFP6 for use on 15 to 20 PII400 Win98 workstations. The database server is a PII400 with 800+mb of RAM, running Win2k and has SQL Server installed but currently unused. After 7 years the current database and program is less than 1gb. At the current rate of growth of the business and new repeat customers, I could see the database and program combined hitting 2gb in 3 years or so.
>
>With the background in place, my questions are:
>
>1) Distribute .exe to the desktops or run from the server?

From server is easier to upgrade. You copy the executable only once. There is a performance penalty (EXE has to be loaded over the server), but I didn't find this to be a problem in practice.

>2) .apps and .prgs with the VFP6.exe on the server or an app.exe on the server?

YourApplication.EXE. Otherwise, every user needs a VFP license, I believe.

>3) What would I gain by using SQL Server? Is there a migration tool for the vfp dbc?

Yes, there is a migration tool. Upsizing Wizard or something. As to gains... I'll let others answer this one. But I don't think it is something urgent.

Hilmar.