Author Topic: MS SQL View and columns' names (Read 5132 times)

pb.Umka · « **on:** March 16, 2007, 04:32:31 am »

I hope some guru give me an answer.

I'm working on ORM generator that is an add-in for the EA.
So my question is how can I get columns' names for a VIEW entity? A VIEW means a MS SQL View.

Thank you in advance..

p.s. I realy need it.

«Midnight» · « **Reply #1 on:** March 16, 2007, 12:54:52 pm »

As yet, there is only limited support for (database) views in EA. As far as things go, I think that views are essentially stereotyped tables, which are themselves stereotyped classes, so the columns would be the properties of the underlying class.

pb.Umka · « **Reply #2 on:** March 19, 2007, 01:22:11 am »

I'm afraid not. We can see view only as plain text. No properties or atridutes. Could you give me any examples or URLs. If I'm not get information about VIEWs' columns I'm afraid I'll refuse to use the EA

Does any anyone has any idea?

thomaskilian · « **Reply #3 on:** March 19, 2007, 03:45:16 am »

VIEW support is quite new. So can you state the build you're using?

pb.Umka · « **Reply #4 on:** March 19, 2007, 03:50:54 am »

I'm using the 6.5.799 build. Is it new enough?

thomaskilian · « **Reply #5 on:** March 19, 2007, 04:24:08 am »

Yes, it is. I guess you want the relations to the tables to be shown. EA doesn't do that. It just gets the SQL text for the View.

pb.Umka · « **Reply #6 on:** March 19, 2007, 04:38:12 am »

As far as I understood there is no chance to find out columns' names. I wonder whether there is any other way to do this with EA or isn't. e.g. import database's schema form any other tool using XML so that EA will be able to give me more info about views.

Shoud I use any data modeler to get all information in this case?

thomaskilian · « **Reply #7 on:** March 19, 2007, 07:10:32 am »

I have no idea if you can get any tool to transform a database scheme to XMI so you can import it into EA. At least I do not remember of any thread talking about that seriously. If you happen to find one, share it with others here.

pb.Umka · « **Reply #8 on:** March 19, 2007, 07:23:13 am »

At the first sight AndroMDA supports kind of transformation, from a batabase schema to XMI. Of course it could turn out one more wrong way. The ERwin modeller dosn't meet my requirements to so it recognizes stored procedures just as plain text. No information about params.

thomaskilian · « **Reply #9 on:** March 19, 2007, 02:32:44 pm »

At least AndroMDA seems to be a product which goes well with EA. Good luck, however...

Sparx Systems Forum

News: