Toad World® Forums

Auto increment in Logical Model


#1

It would be nice to have an auto increment property for the attributes in the logical model.
While converting to a SqlServer model this can be set to an identity column, and if yo convert it to an Oracle db model, then a sequence and a trigger could be generated.
Is that a possibility?


#2

Hello Jan,

Now it’s not possible.
Thanks for your suggestion. We will discuss this issue. I’ve entered your request to our system. - CR # 41 055.
Thanks!

Regards,

Vladka + TDM Team


#3

i’m super interested in a feature like this… while i understand that defining “auto increment” or sequences for columns as elements of an entity of a logical model isn’t technically appropriate. I thiink that adding a property for an entity to denote whether a PK is a “meaningless system generated value”. could then be used by the conversions scripts to implement auto incrementing or sequencing.


#4

Thanks for your remarks and suggestion. We will consider it (added to the CR 41 055).

Thanks.

Regards,

Vladka + TDM Team


#5

any chance it wil be implemented in the version you are currently working with ?

we also look forward to this feature !

Brgds

Kurt


#6

Hi,

I’ve just checked out status of the CR, it’s still open.
I’ll try to find out some more details… and will write you back.

Regards,

Vladka


#7

Hi all,

Let me update the information.

Unfortunately, the CR 41 055 will not be resolved in upcoming full version 3.3.x.
We will consider it for next version. Thanks.

Have a nice day.

Vladka


#8

How about 3.4.???


#9

Hi,

Very sorry, not in 3.4 and not in 3.5.
We will consider it for v. 3.6. Thanks for your patience!

Regards,

Vladka