Author Topic: Reverse engineering for SQL Server 2008 and 2012 (Read 5562 times)

Skippy · « **on:** July 12, 2012, 02:22:05 am »

It seems to be possible to create classes from 2008 code but not to synchronise it or create DLL scripts.

Given that SQL Server 2008 has been out for four years now it would be good if this could be fixed.

Thanks!

Geert Bellekens · « **Reply #1 on:** July 12, 2012, 05:54:44 pm »

What make you conclude you can't create a ddl for SQL Server 2008?
I'm pretty sure I've seen somewhere in the forum or the release notes that it was supported.
Maybe you just need to add the datatypes.

Geert

Skippy · « **Reply #2 on:** July 12, 2012, 06:13:23 pm »

>>What make you conclude you can't create a ddl for SQL Server 2008?

When I try to do this (right-click on table class>generate DLL I get an error message saying 'database not defined'.

However, EA does know the location of my database, and the fact that it is SQL Server 2008, since it was able to use this to create the class tables in the first place.

Please let me know if there is anything else that I need to be doing. Thanks!

Geert Bellekens · « **Reply #3 on:** July 12, 2012, 06:29:29 pm »

Check Settings|Database Types

Geert

Skippy · « **Reply #4 on:** July 12, 2012, 06:58:10 pm »

I haven't got settings>database types in my version (9.3.933). I do have settings>database datatypes; however this seems to be to set the datatypes for an existing database setting. In any case, the default is set to 2008. Unfortunately I still get the same error.

Geert Bellekens · « **Reply #5 on:** July 12, 2012, 07:07:13 pm »

That was what I meant.
In that case I suggest to send a bug report/support request to Sparx.

Geert

RoyC · « **Reply #6 on:** July 13, 2012, 10:45:49 am »

So, just to be clear, if you double-click on the table to display the Properties dialog, on the General page the Database field is set to SQL Server 2008 - correct?

And, if you select Settings > Database Datatypes, the Product Name field on the dialog is set to SQL Server 2008, and the Datatypes list has about 36 entries in it - correct?

If both of those ARE correct, then do as the youthful and clear-sighted Geert suggests and send a bug report to Sparx Support.

skiwi · « **Reply #7 on:** July 18, 2012, 10:09:59 am »

http://www.sparxsystems.com/enterprise_architect_user_guide/9.3/database_engineering/dbmsdatatypes.html

http://www.sparxsystems.com/resources/datatypes/instructions.html

http://www.sparxsystems.com/downloads/datamodeling/DDLDatatypes_SQLSvr2008.xml

Sparx Systems Forum

News: