I already posted this in the SQL Server group, so I apologize for cross-posting.

I am upsizing a VFP database to SQL Server 7.0, and not because JVP thinks it is a good idea *vbg*. The application primarily imports data from another source (text files). I am going to use VFP to read the text files and update the data in SQL Server. In the current database (VFP), I am using character surrogate PKs. Should I use integer PKs in SQL Server? Does this mean using the IDENTITY property?