SQL Server 2012 data types

[skiwi]

EA brings the powerful new database builder.

I create a new SQL Server 2012 data model
I create a table



But


What am I missing?

[skiwi]

On a related note


Where does the DBVersion (shown above) come from,
and how do I change it (it is greyed out)?

[Modesto Vega]

Which version of EA are you using? EA12 (Build 1212) has SQL Server 2012 data types. However, unless you use something exotic there is not much difference between SQL Server 2008 and SQL Server 2012.

[skiwi]

Ah, thanks for that, I'm on EA 1209 as my signature currently says.
It appears that Sparx can release updates faster than our organisation can approve, package, and install them !


I am wondering why, though, Sparx can't provision their website appropriately for those on earlier versions of EA.

[Aaron B]

They should be available with your version of EA, but Database datatypes are stored as reference data within the model.  If you are working with an old repository that was created before those types were introduced, then you will need to import them.

Easiest way to do this at the moment - Create a new local EAP project.  See: Project | Settings | Database Datatypes.  You should find the SQL Server 2012 datatypes.

Export them using: Project | Data Management | Export Reference Data > Model Data Types - Code and DDL.

Import into your repository.

[skiwi]

Would it be too much to ask Sparx to add them to the website?

[skiwi]

Would it be too much to ask Sparx to add them to the website?

Gosh what a good idea, as I encounter this again ...


Meri Kirihimete

[Modesto Vega]

Well Sparx is not very good a keeping this up to date. They don't have data types for SQL Server 2016 and SQL Server 2019, to the untrained eye this looks like Sparx not supporting these 2 versions of SQL Server.

In addition, any other database data types are generic. For example, PostgreSQL or Oracle do not have lists of data types specific to versions.

[skiwi]

It certainly looks like the database tool has gone off the boil.
And yet it would be straight forward, and perhaps even a selling point, to show support current versions of SQL Server and other databases.
I get that there has not been much change in data types since 2012, but for documentary and archiecture purposes being able to show the correct target version is valuable.
And I still don't get why it is not available fro download.

[Modesto Vega]

It certainly looks like the database tool has gone off the boil.
And yet it would be straight forward, and perhaps even a selling point, to show support current versions of SQL Server and other databases.
I get that there has not been much change in data types since 2012, but for documentary and archiecture purposes being able to show the correct target version is valuable.
And I still don't get why it is not available fro download.

In  the v16 beta, all SQL Server data types have been consolidated under one heading, the same way as Oracle, PostgreSQL and other data types. If they release v16 with this feature, it is am improvement.