Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: skiwi on April 22, 2015, 10:40:04 am

Title: SQL Server 2012 data types
Post by: skiwi on April 22, 2015, 10:40:04 am
EA brings the powerful new database builder.

I create a new SQL Server 2012 data model
I create a table
(http://i306.photobucket.com/albums/nn245/copperkiwi/Sparx/No%20datatypes_zpstzfguo5t.png)


But
(http://i306.photobucket.com/albums/nn245/copperkiwi/Sparx/No%20datatype%20download_zpspt6cb0ex.png)

What am I missing?
Title: Re: SQL Server 2012 data types
Post by: skiwi on April 22, 2015, 10:46:16 am
On a related note
(http://i306.photobucket.com/albums/nn245/copperkiwi/Sparx/DBversion_zpsgh7fdwys.png)

Where does the DBVersion (shown above) come from,
and how do I change it (it is greyed out)?
Title: Re: SQL Server 2012 data types
Post by: Modesto Vega on April 22, 2015, 06:09:39 pm
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.
Title: Re: SQL Server 2012 data types
Post by: skiwi on May 06, 2015, 12:31:09 pm
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.
Title: Re: SQL Server 2012 data types
Post by: Aaron B on May 06, 2015, 12:56:22 pm
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.
Title: Re: SQL Server 2012 data types
Post by: skiwi on May 11, 2015, 02:16:27 pm
Would it be too much to ask Sparx to add them to the website?
Title: Re: SQL Server 2012 data types
Post by: skiwi on December 17, 2021, 12:25:29 pm
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
Title: Re: SQL Server 2012 data types
Post by: Modesto Vega on December 17, 2021, 08:50:48 pm
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.
Title: Re: SQL Server 2012 data types
Post by: skiwi on December 30, 2021, 06:01:03 pm
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.

Title: Re: SQL Server 2012 data types
Post by: Modesto Vega on January 13, 2022, 02:11:49 am
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.