Messages

1

Bugs and Issues / using Import DB Schema from ODBC ....

« on: March 05, 2009, 02:45:16 pm »

Hi There:

I have to update some objects of my current SQL Server DB in EA 7.1 I try to import tables using "Import DB Schema from OBDC source" Click in Synchronize options.

The tables keep links and GUID are the same but General Tab - field notes disappear after the Import. Do I have any way to upgrade my DB with out lost comments in my tables ? Ay suggestion ?

2

Automation Interface, Add-Ins and Tools / Re: Generating Sql script via Code Template

« on: April 01, 2009, 01:08:26 pm »

Hi gdodd12:

Did you generate a custom SQL script using code template editor?
I did a bit of work to generate a list of objects that are new in a package using version and modified date attached to the tables but I get stack to link this file with the DDL code generator.

3

Automation Interface, Add-Ins and Tools / Re: GENERATE DDL code -

« on: March 25, 2009, 10:48:38 am »

David:

I like your idea, simple and should work well, tough, it is not as automatic as I would like it. I can break my model and still use one big data model diagram.

Just a quick note - EA can generated DDL code from a selected tables from a long list. Of course, one by one using  <Ctrl> key and a single file as an option.

 

4

Automation Interface, Add-Ins and Tools / Re: GENERATE DDL code -

« on: March 24, 2009, 02:59:36 pm »

Dear Midnight,

Thanks for your kind reply, I have been using the options to generate DDL code extensible already.

Currently, I have many tables in the same package and I need to be able to generate the DDL code in selected way according with the version.

All the tables are at the moment in the same package, to consolidate a unique data model of my Database with old and new tables.

If you have any idea or suggestion please let me know.  :-?

Cheers,

5

Automation Interface, Add-Ins and Tools / GENERATE DDL code -

« on: March 20, 2009, 11:38:30 am »

Hi there:

I need to generate a DDL code from my proyect, must be base on the version of the tables.
EA assign the next configuration
Element Type = Class
Stereotype = Table
Element Field = version
Element field = 1.0

Any suggestions ? Do I need to use an Add-In or there is something to set up during the DDL code generation ?

 

6

Automation Interface, Add-Ins and Tools / compare DDL code

« on: March 20, 2009, 11:49:44 am »

Hi EA users:

EA give me an option to compare my package in EA with a database  in SQLServer. How can I generate and script with this differences.

My organization is doing changes for next release of the our applications, the Databases need to have some changes.

The changes are now in EA- How can I generate DDL code just with this changes ?  

Cheers,

Carmenza