Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: bu66le on November 22, 2004, 07:12:11 pm

Title: EA and SQL scripting
Post by: bu66le on November 22, 2004, 07:12:11 pm

We know that EA eventually stores everything into database or .EAP file, isn't it wonderful if there is a built-in support for SQL scripting in EA for tasks such as batch rename, batch copy paste (attributes and/or operations) etc? I personally believe this is a very flexible feature that would definitely increases productivity :D
What do u think? Should I write to feature request column?

Title: Re: EA and SQL scripting
Post by: thomaskilian on November 22, 2004, 10:49:57 pm

Doesn't your standard database support such kind of tasks already?

Title: Re: EA and SQL scripting
Post by: bu66le on November 23, 2004, 01:20:47 am

standard database does support it but I'm not sure how to do that with .EAP file, cos that's what I'm working with ;D

Also, editing the tables directly would introduce inconsistency if we are not careful enough, so I think there should be some kind of abstraction (view?) to be provided... or they are there already?

Title: Re: EA and SQL scripting
Post by: thomaskilian on November 23, 2004, 03:15:03 am

Maybe I'm totally wrong, but it looks like you need an automation interface. Of course EA does not permit to actually manipulate its tables. But with automation you could do all these things you request.

Title: Re: EA and SQL scripting
Post by: Bruno.Cossi on November 23, 2004, 05:13:13 am

The .EAP file is nothing but an MS Access database, .MDB file with the extension changed. Just open it using MS Access and you will see :-)

Bruno

Quote

standard database does support it but I'm not sure how to do that with .EAP file, cos that's what I'm working with ;D

Also, editing the tables directly would introduce inconsistency if we are not careful enough, so I think there should be some kind of abstraction (view?) to be provided... or they are there already?

Title: Re: EA and SQL scripting
Post by: bu66le on November 23, 2004, 05:15:41 pm

thomaskilian is right, I should use the automation interface... it seems like modeling tools such as EA and rational rose prefer VB over other languages for scripting ::)

thanks

Title: Re: EA and SQL scripting
Post by: mikewhit on November 24, 2004, 12:46:26 am

... or Perl ...
http://www.sparxsystems.com.au/cgi-bin/yabb/YaBB.cgi?board=Automation;action=display;num=1096035939;

Title: Re: EA and SQL scripting
Post by: Bruno.Cossi on November 24, 2004, 05:47:45 am

... or anything that supports COM interfaces...

Bruno