Identity Seed generation in DDL

General Questions/Discussions
1

I am using VP Enterprise 8.0 to generate DDL for MS SQL. In the entity specification, I was able to designate an IDENTITY for my primary key, which generated:

CREATE TABLE Drug (DrugID bigint IDENTITY NOT NULL,…

But my DBA pointed out that I did not have a seed value for the IDENTITY:

CREATE TABLE Drug (DrugID bigint IDENTITY(1,1) NOT NULL,…

I can not find a spot in the entity specification to enter the seed (1,1).

Can anyone help, please?

Thanks a lot! Walt

2

Hello Waltmoser,

Thank you for your message and I’m sorry that currently we do not support defining the seed. I’ve pass your issue to our engineers to follow-up, and will get back to you once there are any feedback. Feel free to contact me if you need any help.

Best regards,
Rain

3

Hi, Rain. Thanks for the quick response. Sorry this does not work yet, but it can’t do it all.

I am considering generating my own post-process that would search the DDL for “INDENTITY” (or something like that), and then update the DDL appropriately. Do you have custom integration points in your software that would help me as a workaround for this issue?

Thanks,

Walt