Changing Datatype in diagram model

[jsnv]

hi, can anyone tell me how to change datatype in diagram model automatically and affect all diagrams ?

eg. change datatype varchar(xx) into nvarchar(xx)

thx

[Eve]

I'm assuming you're wanting to change all attributes (or columns) with the type varchar to type nvarchar, not just one attribute as it is shown on multiple diagrams.

The best I can suggest would be a SQL call on your EA model.

Something like: update t_attribute set Type='nvarchar' where Type='varchar' should do the job.

[jsnv]

sory i'm new to EA, where do i input statement "update t_attribute set Type='nvarchar' where Type='varchar' in EA?

is it  i must generate ddl script first?

thx

[thomaskilian]

The EAP files are MS Access databases. You can execute above SQL on that using MS Access.

Alternatively try the following (this is a hack which might not work )
- Ctrl-F to open the Search window
- Advanced
- New Search
- name it Update or Dummy or whatever
- check SQL Editor
- OK
- Paste the query in the new window
- Save
- Run Search

The last action will execute the SQL. You should delete the "Search" filter afterwards - since it's a hack, not a search!

[jsnv]

WOW it works  
i'm using ms access to do it

thx all

[roman]

The EAP files are MS Access databases.

Thank you Thomas, this tells everything.

I'll suggest a next, may be more safe way:

• Create a blank mdb-database
  
• \Tables\Link, link all tables from eap-project. There is no
  file-extension problem. Access can read mdb-file with eap file-extension.
  
• Build in this new mdb-file you filters, queries, ...
  

This way you access only the data in eap-file, much more, you can build your eap-model-administration mdb-file.
Just change eap data source.
But! Backup eap-file, 2x think about the change step, then do it, of course!

Thank you for this tip. ;-)

Roman