SQL 2008 Data type

[darin]

Support for MS SQL Server 2008 data type

[«Midnight»]

Don't know Darin...

I have requested this a while back, and I think others have too. My guess - without any evidence though - is that we might see it in EA 7.5 (probably early next year). That would fit the pattern of new SQL dialects being supported in the next EA version after the SQL version went into commercial production (i.e. not widespread beta or CTP).

In the meantime, make a feature request to Sparx. Use the Feature Request link near the bottom of any forum page. If this has not yet made the cut for implementation, perhaps additional requests will give it the needed impetus.

David

[darin]

I still like to edit my create scripts and not just use the generated stuff (a bit of a design review)
But for anyone else who needs to move forward while waiting, here is the SQL 2005 datatype I use as surrogates to the new ones (the ones I've use so far)
HiarchcyID = nvarchar(0) - not sure how to set nvarchar(max) in ea
Geography and Geometry = varbinary(0)
Geography and Geometry (WKT) = varchar(0)

When I review the generated script it's just a matter of modifying the datatypes to the SQL 2008 types (really not that much work)