Author Topic: Cant properly generate DDL from a database Model (Read 8536 times)

SBB · « **on:** June 28, 2012, 10:16:55 pm »

There are currently an issue in EA Version 9.3 933 (Ultimate Ed.) and before, which prevent us from properly generating DDL from a database model.

When defining the RAW datatype for Oracle, there is no possibility to declare the size of the attribute (see attachment). This is necessary, as RAW requires it:
Raw binary data of length size bytes. Maximum size is 2000 bytes. You must specifysize for a RAW value.

The generated DDL looks like this:

RAW_ATTR RAW,....

instead of:

RAW_ATTR RAW(50),....

It's also not possible to change existing database datatypes under Settings > Database Datatypes, as all existing Size fields are greyed out (see attachment).

Thank you for your support.

Best regards.

hd · « **Reply #1 on:** June 29, 2012, 07:56:10 am »

Download and import Oracle data types updated in build 933...

Data types required for Oracle data modeling updated to include missing data types.

http://www.sparxsystems.com/resources/index.html
http://www.sparxsystems.com/resources/datatypes/instructions.html
http://www.sparxsystems.com/downloads/datamodeling/DDLDatatypes_Oracle.xml

Alternatively, export the datatypes from EABase.eap or EAExample.eap installed with build 933, and import as reference data into your project.

Skippy · « **Reply #2 on:** July 12, 2012, 07:46:52 pm »

I can't generate a DDL at all for SQL Server 2008.

Here's the thread:

http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1342023725/5#5

hd · « **Reply #3 on:** July 13, 2012, 08:03:53 am »

Are the SQL Server 2008 data types installed?
http://www.sparxsystems.com.au/downloads/datamodeling/DDLDatatypes_SQLSvr2008.xml

Skippy · « **Reply #4 on:** July 13, 2012, 08:22:53 pm »

>>Are the SQL Server 2008 data types installed?

Yes

Skippy · « **Reply #5 on:** July 22, 2012, 12:57:50 am »

I was wondering if there had been any movement on this.

I am trying to synchronise a table generated originally by EA with the underlying database. I get an error 'SQL Server 2008 is an unsupported language. You cannot reverse engineer this class.'

This makes no sense, because EA already has reverse engineered it. Apparently it just can't synchronise it later. Any suggestions?

hd · « **Reply #6 on:** July 23, 2012, 07:52:03 am »

Looks to me like you're trying to synchronize a data model by importing from source files.

Suggest you try Code Engineering | Import DB Schema from ODBC?

Skippy · « **Reply #7 on:** July 23, 2012, 03:31:01 pm »

>>Looks to me like you're trying to synchronize a data model by importing from source files.

>>Suggest you try Code Engineering | Import DB Schema from ODBC?

This works. (indeed, that's how I created the UML model of the database in the first place). However I need to synchronise a small change in the underlying database to the UML model. If I import the entire schema I will lose the links I have set up to that schema from other parts of the model.

EA understands that I want to synchronise: it just can't do so for SQL Server 2008, even though the DLL templates are installed and it was able to create the schema automatically in the first place.

Geert Bellekens · « **Reply #8 on:** July 23, 2012, 04:23:29 pm »

Skippy,

AFAIK EA just doesn't have a "synchronize database" functionality.

You can import from ODBC again, and it will try to merge things as good as it can, but I don't see that as a real synchronization.

Geert

Skippy · « **Reply #9 on:** July 23, 2012, 05:04:52 pm »

>>AFAIK EA just doesn't have a "synchronize database" functionality.

So when it says 'SQL Server 2008 is an unsupported language' it doesn't mean that just this version is unsupported, but that all database synchronisation is unsupported.

That's a pity. However, thanks very much for clearing this up for me!

Sparx Systems Forum

News: