Auto increment in Logical Model

Toad Data Modeler
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