Author Topic: SQL Server 2012 data types  (Read 12231 times)

skiwi

  • EA Practitioner
  • ***
  • Posts: 1979
  • Karma: +44/-82
    • View Profile
SQL Server 2012 data types
« 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



But


What am I missing?
Orthogonality rules
Using EA15.2 (1555) on Windows 10 Enterprise/64 bit. Repositories in SQLServer2019 & Access2003/JET4.0. WebEA on Pro Cloud Server 4.2.64

skiwi

  • EA Practitioner
  • ***
  • Posts: 1979
  • Karma: +44/-82
    • View Profile
Re: SQL Server 2012 data types
« Reply #1 on: April 22, 2015, 10:46:16 am »
On a related note


Where does the DBVersion (shown above) come from,
and how do I change it (it is greyed out)?
Orthogonality rules
Using EA15.2 (1555) on Windows 10 Enterprise/64 bit. Repositories in SQLServer2019 & Access2003/JET4.0. WebEA on Pro Cloud Server 4.2.64

Modesto Vega

  • EA User
  • **
  • Posts: 821
  • Karma: +23/-8
    • View Profile
Re: SQL Server 2012 data types
« Reply #2 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.
« Last Edit: April 22, 2015, 06:10:06 pm by modesto.vega »

skiwi

  • EA Practitioner
  • ***
  • Posts: 1979
  • Karma: +44/-82
    • View Profile
Re: SQL Server 2012 data types
« Reply #3 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.
Orthogonality rules
Using EA15.2 (1555) on Windows 10 Enterprise/64 bit. Repositories in SQLServer2019 & Access2003/JET4.0. WebEA on Pro Cloud Server 4.2.64

Aaron B

  • EA Administrator
  • EA User
  • *****
  • Posts: 941
  • Karma: +18/-0
    • View Profile
Re: SQL Server 2012 data types
« Reply #4 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.

skiwi

  • EA Practitioner
  • ***
  • Posts: 1979
  • Karma: +44/-82
    • View Profile
Re: SQL Server 2012 data types
« Reply #5 on: May 11, 2015, 02:16:27 pm »
Would it be too much to ask Sparx to add them to the website?
Orthogonality rules
Using EA15.2 (1555) on Windows 10 Enterprise/64 bit. Repositories in SQLServer2019 & Access2003/JET4.0. WebEA on Pro Cloud Server 4.2.64

skiwi

  • EA Practitioner
  • ***
  • Posts: 1979
  • Karma: +44/-82
    • View Profile
Re: SQL Server 2012 data types
« Reply #6 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
Orthogonality rules
Using EA15.2 (1555) on Windows 10 Enterprise/64 bit. Repositories in SQLServer2019 & Access2003/JET4.0. WebEA on Pro Cloud Server 4.2.64

Modesto Vega

  • EA User
  • **
  • Posts: 821
  • Karma: +23/-8
    • View Profile
Re: SQL Server 2012 data types
« Reply #7 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.

skiwi

  • EA Practitioner
  • ***
  • Posts: 1979
  • Karma: +44/-82
    • View Profile
Re: SQL Server 2012 data types
« Reply #8 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.

Orthogonality rules
Using EA15.2 (1555) on Windows 10 Enterprise/64 bit. Repositories in SQLServer2019 & Access2003/JET4.0. WebEA on Pro Cloud Server 4.2.64

Modesto Vega

  • EA User
  • **
  • Posts: 821
  • Karma: +23/-8
    • View Profile
Re: SQL Server 2012 data types
« Reply #9 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.
« Last Edit: January 13, 2022, 09:38:07 pm by Modesto Vega »