Always have a clustered index that is preferably also the primary key.
Use the new upsizing wizard.

>Hello experts,
>
>Are there any definitive articles with tips on up sizing a large VFP database to SQL? Specifically:
> - tips on using SSIS for the migration?
> - tips on using the (new) upsizing wizard?
> - datatypes, clustered indexes?
>
>Thanks!