Messages

1

Suggestions and Requests / Documentation of DDL script generation

« on: January 30, 2009, 03:58:35 am »

I've been learning how Enterprise Architect maps tables in the data model to SQL Server scripts. I've been doing this largely by exporting my data model to DDL scripts and by importing SQL Server tables.

I'd like to request documentation on how Enterprise Architect does this mapping.

For example, documentation could indicate that the IDENTITY column in a SQL Server DDL script is mapped from the auto number property of a column in a table in the data model.

Many thanks, keep up the good work
Ed Vowles

2

General Board / Re: Specifying SQL Server 2005 database schema

« on: February 04, 2009, 08:18:06 pm »

I have this problem too. Did you get a work around cseha?

As Elham points out, the USER level-0 type is on the way out and really we want enterprise architect to set SCHEMA as the level-0 type.

How do you specifiy the database schema for sql server 2005/2008 tables??!

Ed

3

General Board / Re: SQL server IDENTITY column

« on: January 30, 2009, 03:48:03 am »

Thanks Midnight

4

General Board / Re: SQL server IDENTITY column

« on: January 28, 2009, 08:46:57 pm »

I think I may have answered my own question:

Element menu -> attributes -> select column -> column properties -> auto number

Is this documented in any of the online resources? I'd like to read up on how enterprise architect maps tables in its data model to SQL server scripts.

Ed

5

General Board / SQL server IDENTITY column

« on: January 28, 2009, 08:14:47 pm »

I would like to use enterprise architect to set a column on a table as an identity column (SQL server 2005). When I generate the table DDL I would like output to include the IDENTITY keyword. Something like:

Code: [Select]

CREATE TABLE Customer (
      ID int IDENTITY NOT NULL,
      Name nvarchar(50) NOT NULL,
)
;
Is this possible?!

Thanks
Ed