>I always use 36 char guids ( formatted exactly like SQL Server UniqueIdentifiers ) as my surrogate keys in my VFP apps. When I upsize, using the upsizing wizard, I can only upsize as character(36) Then I must modify the tables in SQL Server to change the char(36) fields to uniqueidentifiers ( I realize I could probably fiddle the scripts on the vfp end to cast the values to binary(16) somehow, but that hardly seems a time saver.
>
>If I do my conversion with DTS, I am faced with pretty much the same thing.
>
>I realize that though these fields are correctly formatted and NOCPTRANS on the VFP side, they are not the same as SQL Server UniqueIDs
>
>Is there a trick to facilitating this upsizing (assuming I don't have my structures already in Visual UML etc ) to cast my guids as unique ids ( and keep my pk indexes )
>
>Suggestions appreciated
>
>TIA
Charles,
I didn't use upsizing but with SPT and alike SQL server recognizes 36,38 bytes versions, 16 bytes version and strconv(x,15) version.
Cetin