DAS, UDS and Large Integers problem

Anyone know what should I use in my Dbschema files for a large integer when dd'ing to an MSSQL BIGINT ?
CreateViaSql fails with BIGINT, INTEGER(19), and LONG

Cheers

/Nick

Find more posts tagged with

Comments

Migrateduser

looks like a bug in DD. if you won't be exceeding values beyound +- 2^32, you can use integer.

Migrateduser

BTW, to overcome the problem for now, you can create the destination table ahead of running the deployment, with the BIGINT data type for the appropriate column you want. DD won't create the table if it already exists. It should be able to map the value for such a BIGINT column correctly, provided the JDBC driver returns the right JDBC equivalent data type for that bigint column.

Migrateduser

Thanks again
Not quite the reply I'd hoped for ;-) but the important thing is that it seems to work.

(BTW I need to have BIGINTs because of the way that I'm generating unique IDs by using a Perl callout from the DCTs to generate the ID from seconds elapsed since 1970 + 2 random numbers)