>Once the VFP tables are upsized to SQL Server, all my auto incremental fields are converted to Integer. What should I do to adjust the SQL Server database so it would know that this is an auto incremental field?

In SQL Server you should specify IDENTITY propertry for such column.