>There are probably 10 times the questions than I can think of so I thought I would throw out the ones that come to mind as a starter but I am open to others just stating their experiences of what they had to re-write when transitioning. Not even sure where to start but there goes:
>
>- is there any type of data that does not match up between VFP and SQL?
>- can all types of queries bring down the same data to VFP i.e. selecting into an array, local cursor etc or do some things need rewriting?
>- does referential integrity need to be handled by the back-end or if the logic is in the front end, can it stay there for now?
>- do the table structures need to change at all e.g. if the table uses a primary key generated from a "keys" table (as the framework I use does), does it have to change to an AUTOINC field etc?
>
>That's enough for now...
>
>Thanks,
>Albert

All these questions depends of what front end they will choose.
On top off my head:
1. SQL Server has no MEMO or GENERAL field types, but it has n/varchar(xxxx), varbinary(xxxx) field types instead.
2. No, all queries from SQL Server come as CURSOR/DataTable/DataReader.
3. RI should be handled by backend, because nobody can guarantee that the data can be modified only by your front end. Somebody can use SSMS to modify records.
4. No, you can use the same PKs.