Automatic Min Value for Sequential Data Generator

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
corneliusd
Posts: 27
Joined: Thu 21 Dec 2006 08:45
Location: Portland, OR
Contact:

Automatic Min Value for Sequential Data Generator

Post by corneliusd » Mon 09 Dec 2019 19:54

I'm using dbForge Data Generator for Oracle and want to add customers to an existing customer table. The Customer_ID field is an Integer with a "unique" constraint but it is not an auto-inc field. When I use the Data Generator to add customers, I am using the ID (Sequential) generator but have to manually set the Min value to one more than the last ID currently in the customer table.

What I would like to do is have the script automatically figure out what the min value should be by starting off with Max(Customer_ID) + 1.

Is there a way to do this?

Thanks,
David.

alexa
Devart Team
Posts: 2856
Joined: Fri 24 Jun 2011 14:17

Re: Automatic Min Value for Sequential Data Generator

Post by alexa » Tue 10 Dec 2019 14:35

You could unselect 'Truncate' in the table properties.

corneliusd
Posts: 27
Joined: Thu 21 Dec 2006 08:45
Location: Portland, OR
Contact:

Re: Automatic Min Value for Sequential Data Generator

Post by corneliusd » Tue 10 Dec 2019 16:43

That's not the issue. Of course, I'm not truncating the data first because then I wouldn't be adding customers but simply replacing my entire test set--not what I want to do.

The issue is that if I don't manually set the minimum value for Customer_ID to 1 greater than the current maximum Customer_ID, then the script generates duplicate Customer_ID values--the constraints are disabled during generation.

Since I want to run this every few days or weeks as I need more test customers, I'm looking for a way to automatically set the last Customer_ID to a valid minimum.

Thanks,
David.

alexa
Devart Team
Posts: 2856
Joined: Fri 24 Jun 2011 14:17

Re: Automatic Min Value for Sequential Data Generator

Post by alexa » Wed 11 Dec 2019 15:59

Thank you for the reply.

There is no such a possibility.

Though, you can add a suggestion on the UserVoice forum where other users can vote for it https://devart.uservoice.com/forums/132897-dbforge-studio-for-oracle

We collect and analyze the information from this forum in order to make a proper roadmap for the future product releases.

Post Reply