>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?
I would recommend using GUIDs - that way you don't have to mess with keeping the ones added in SQL Server in synch with the ones added in VFP, or with making sure you can override an IDENTITY field.
You can create them in VFP with the code in this link.
http://support.microsoft.com/support/kb/articles/Q269/3/87.ASPIn SQL Server, just use NEWID() to get a new GUID and the UniqueIdentifier data type for the PK field.
Insanity: Doing the same thing over and over and expecting different results.