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 Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
