SQL 2005 Database type in property

[AlexFromQx]

I am process of evaluating Enterprise Architect, and I was wondering how can I change the database type to SQL 2005 when creating database domain models?

There is a choice of SQL Server 7 and SQL Server 2000 for the table property but I just can’t find the SQL Server 2005 option as database type.

According to release notes EA 6.5.800 there is added support for SQL Server 2005 xml data type, but I can’t find this xml field type when database type is SQL Server 7 or SQL Server 2000.

[«Midnight»]

I've poked Sparx about this a few times, but no response beyond using SQL 2000. That seems to be safe so far.

As far as supporting XML as a data - or storage - type I have no idea. It does not appear in the SQL Server 2000 dialog, but that could be due to the way that SQL perceives XML - more as a way of storing data of arbitrary types than as a data type in itself. Of course, I'm guessing here.

Perhaps Sparx could provide us with a bit of clarification to go with the release notes.

[AlexFromQx]

I found another issue related to 2005 SQL server.
In SQL 2005, schema may not be SQL server user, but rather virtual group of tables.

It seems that only way to group the tables to schema is to use Owner tag value. But when this is set, the DDL script generated will fail in execution while processing the comment.

EA adds the Owner also to the comment lines “sp_addextendedproperty” and this causes the failure of the DDL script execution as the schema is not real user.

[«Midnight»]

I strongly suggest you report this to Sparx as a possible bug. You should do this directly rather than through this forum, so that it goes directly into the 'hopper' at Sparx.

You can reach the appropriate page from the EA main menu via Help | On-line Resources | Bug Report Page.

David

[AlexFromQx]

David,
Thanks for the advice, but as I am evaluator of the EA I don’t have a user-id for the registered user site where the bug incidents are reported.

I was hoping to get some solution for this issue by this channel. I guess I have to do the evaluation of EA later phase once this is solved by Sparx.

Anyhow thanks for your responses.

[Paolo F Cantoni]

Use the Support link at the top of this page...  You can submit a bug report using the link at bottom left of the new page.

HTH,
Paolo

[AlexFromQx]

Paolo,

Thanks, I have now created a bug and reference to here. Hope Sparx update this thread soon...

[AlexFromQx]

I received answer from Sparx for the bug reported and here it goes...

To use the SQL Server 2005 datatype, go to Settings | Database | Datatypes... And add the xml datatype to SQL Server 2000, giving it a common type of 'text'.

Schema support for SQL Server 2005 is under way, and should be available in the new year.

[«Midnight»]

While less than perfect, this is probably good enough to work with for now. At least the wait will not be long. Sparx tends to mean the "new" part of the new year, as opposed to the Wintel crowd who generally mean "before the end of" the new year.