How do i set the defualt DataType of ERD to SQL?

[peter king]

Hi Friend,

I use EA 7.5 corp.

I need to set teh default Data Type of the attribuets of the Entitites to MS SQL servers types, how do i do this? i need to do this gloablly so that when i create anther ERD i dont need to rchaneg the type to SQL type?

TY

[smendonc]

I've done this by displaying the Code Generation Toolbar and setting the displayed default database option on it.  There is probably a better way to do this but as I do it infrequently its the one I remember.

From the View Menu --> Toolbar --> Code Generation.

Stan.

[peter king]

Hi Friend,

I think you'v misunderstood my Q.

When i open a project to create an ERD and drag and Drop a table i want it by defualt to have MS SQL server types.....

When i double click the tbale in the genaral tab in the Database drop down box it will show MS SQL server as defualt.

Thanks

[smendonc]

[edit]When i open a project to create an ERD and drag and Drop a table i want it by defualt to have MS SQL server types.....

When i double click the tbale in the genaral tab in the Database drop down box it will show MS SQL server as defualt.
[/edit]

This is the behavior that results when the database is set as I described above.  It will work for all new tables created after the setting is changed.

If you already have tables and need to reset them to a different database type, then I think you will need to write a script or use the api.

http://www.sparxsystems.com/uml_tool_guide/uml_modeling_tool_features/codetoolbar.html

Regards,
Stan.