Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - bilon

Pages: [1] 2 3
General Board / Columnstore indexes for Sql Server tables
« on: January 02, 2018, 09:52:28 pm »

when modelling index for Sql Server table, I can't see any option for columnstore indexes. Is there any way how to accomplish this?



we currently face the same error as described in this topic,5480.msg125188/topicseen.html#msg125188
It is marked as solved, but I can't see there any solution. Is anybody able to help me? After adding new element to the collection and setting it's properties, subsequent update of this element ends up with mentioned error. Interesting is, that when not setting StereotypeEx property, it works fine. It works fine too (even when setting StereotypeEx property) when used against eap file. But in MySQL repository it ends up with the error.


In my case, the elements are relatively simple, so I can't see any problems in duplication. Anyway, if duplication is possible through user interface, why it is not possible in scripting?

Same as the original.

Looks to be pretty hard work  :(

Any idea how duplicate element from script? I need to do in script the same as do the browser functions "Copy element to clipboard" and "Paste element from clipboard".

Is there anybody capable to help me?

MDA transformations are quite new topic for me. After reading some kind of "documentation", I must say I have no idea what I should manipulate. There's some DDL Transformation, but this (according the documentation) is the process of transforming logical model into physical model. My problem is, that I have valid physical (data) model for Sql Server, but EA generates bad DDL script from it. Anyway, manipulating MDA transformations looks like pretty low level activity - it is in no way "simple workaround" of core product error.

General Board / Sql Server Datetime2 datatype length poorly generated in DDL
« on: September 15, 2017, 10:34:50 pm »
When setting DATETIME2 length to non-zero value, it's ok. For zero length EA generates DATETIME without length, which defaults to 7 in Sql Server. Does anybody know some workaround?

For index, TABLESPACE property works well, for primary{unique key it doesn't. Any idea how to do it?

General Board / Re: How to remove foreign keys from duplicated tables
« on: September 15, 2017, 08:12:23 pm »
No other idea?

General Board / Re: How to remove foreign keys from duplicated tables
« on: September 12, 2017, 08:21:03 pm »
I tried this at the very beginning. It creates completely new key.

General Board / Re: How to remove foreign keys from duplicated tables
« on: September 11, 2017, 06:58:39 pm »
The connectors can't overlap. They join different tables (original table with master table vs. duplicate table with master table).

General Board / How to remove foreign keys from duplicated tables
« on: September 09, 2017, 01:19:11 am »
I've duplicated table (through Copy / Paste element) with foreign key. I want to remove that key from the duplicate. When trying this through constraint, it tells me that correct way is through association. But I can't see any association for the duplicate in the diagram? Any idea how to do it?

We have recently migrated from EA10 to EA12 and some of our report templates give different rtf output then in EA10. It looks, EA12 inserts additional newline at the end of the "Notes" field. Any idea how to remove it?

Pages: [1] 2 3