BTW I don't know VFP's upsizing wizard but I think with SQL DTS you can specify datatype for SQL server side.
With VFP's upsizing wizard I remember "generate code". Take that code and change SQL server type to be uniqueidentifier (and possibly ROWGUIDCOL) and run with osql,isql or query analyzer (or even VFP).
Cetin