>Hi Charles.
>
>>uniqueidentifier is not an option on the dropdown. I thought I might get it on there by fiddling the typemap table to make uniqueidentifier one of the choices for character (in place of text)
>>but when I rebuild the app I get an operator/operand type mismatch ( which it is technically as only a very specific string would be seen by SQL as a uniqueidentifier.
>
>I looked into this. It's a goofy error caused by the TYPEMAP table already being open (likely because you added the uniqueidentifier record to it). I've fixed that but in the meantime, you should be able to CLOSE DATA ALL before running the Upsizing Wizard and it should work.
>
>A couple of other things:
>
>- I added several missing data types: uniqueidentifier, ntext, nchar, nvarchar, etc.
>- There's a weird versioning thing in the TYPEMAP table and associated code. I've taken care of that too, but in the meantime, you probably have to put "SQL Server4x" into the SERVER column of the new record in TYPEMAP.
>
>Doug

Okay, doing a close data all did get me to the column mapper and I was able to pick uniqueidentifier. But at the end it said the table could not be upsized BUT

the good news is I think the only problem is the size of the wizard column holding the sql type truncates uniqueidentifier.

I am going to try hacking the width of that column and see if there isn't any other place it gets truncated

the error using bulkxmlload by the way is that the character expression is invalid for the cast to uid - which means something is getting lost in the Xml rendering
May try it again without the dashes as I currently am using a full guid(36) but maybe it will eat a GUID(32)

here is what was generated by the upsizer

/* Create table 'account_credits' */
CREATE TABLE [account_credits] ([cid] uniqueidentif NOT NULL , [cinmates_id] uniqueidentif NULL , [ddate] datetime NULL , [ctype] char(10) NOT NULL , [yamount] money NOT NULL , [ccheck_number] char(25) NOT NULL , [mcheck_writer] text NOT NULL , [cmethod] char(15) NOT NULL , [mnotes] text NOT NULL , [cdeposit_batch_id] uniqueidentif NULL , [cuserid] char(10) NOT NULL , [cshiftlog_id] uniqueidentif NULL , [cdeposit_number] char(8) NOT NULL , [linitdep] bit NOT NULL , [dtxndatetm] datetime NULL , [cdeposit_batches_id] uniqueidentif NULL , [lreconciled] bit NOT NULL , [limported] bit NOT NULL , [cexports_id] uniqueidentif NULL , [ctransfer_batches_id] uniqueidentif NULL , [cproducts_id] uniqueidentif NULL , [cpurchases_id] uniqueidentif NULL , [cjdi_lineitems_id] uniqueidentif NULL , [cbookings_id] uniqueidentif NULL , [cacct_events_id] uniqueidentif NULL , [cdeposit_types_id] uniqueidentif NULL , timestamp_column timestamp)