>Upsizing is never an easy task. Upsizing the autogenerating key feature from VFP 7 to SQL-server is not fully possible. In VFP 8 you can add a new record in a table and having the new PK available inmediately. When using SQL-Server, you must do this either via local views or SPT. The new PK is only available whenever you've saved the record and requested the same row again from the server. The usizing process would create a difference between handling local en remote data.

The upsizing wizard will certainly allow for identity insertions at the SQL side (SET IDENTITY_INSERT {table} ON): in this way, both data ends will be in sync in respect to structure and contents.