Messages

1

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

« on: March 31, 2009, 11:50:40 pm »

Interesting.

I really just was hoping to use the Code Generation templates to create something. If they can use them to build .cs files, I assume there is a way to build SQL scripts off of objects as well. I just don't know any of the syntax for that code generation language they are using, nor can I find it referenced anywhere. I just want my BA's to be able to build objects in the diagrams, than right-click and generate sql scripts with my custom code generation script.

2

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

« on: March 31, 2009, 06:29:10 am »

The SDK was pretty useless honestly, unless I was looking in the wrong area. I will take a look at the data modeling thing. I basically just want to create a script that can be run against an object in the EA Diagram, and produce a Sql script. That is why I need some reference of all the keywords that can be used in those code generation templates.

3

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

« on: March 31, 2009, 03:38:03 am »

Hi. I am trying to generate a sql script off of new objects placed in the EA Diagram. I was thinking I could create a custom Code Template to do that. For example, someone would create a new class shape in a diagram, along with attributes and some links. They could then choose generate code and use my custom template to generate the sql that uses that class, attributes, and links. Is this possible? Is there documentation that lists all the key words to write the custom code templates?