I'd go Integer, unless you're planning to use Replication on SQL Server to go off-line. Then I'd use a GUID length string (and a GUID for the (surrogate) prim key).
Cheers,
Andrew
>We are about to re-structure one of our flagship application to make it scalable to higher dimension of DBMS. It is our intention that our databases in VFP platform can be upsized to SQL Server without much pain in the long run. Are we going to create in each table a field that will contain unique values which will serve as surrogate key. If yes, is it a string/character or integer type? Please guide me...
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.
