>Hi
>
>I written a multi-user WIP system that been happily running on a MS 2003 network for 5 years Software uses Foxpro s own internal database engine.
>
>Customer has now decided the time is right to move on to MS SQL 2008, they are quite happy to keep the interface running under VFP9. This is partly
>due to the interface being quite complex.
>
>Whilst there are only 10 tables in the database and only really two main tables the job flow can get quite complex as jobs can split in two
>go back through many cycles.
>
>Can anyone recommend any good books/videos etc on exactly one can go about taking your VFP application and moving it to MS SQL.
>
>Any help extremley apppreciated
>
>Rob
Rob,
Why move to MS SQL 2008? MS isn't actively supporting 2008 or 2008R2 and they are in process of ending support. Best to move to SQL 2014.
How big are you tables? (i.e. what's the highest row count on your biggest table)