Devart Forums

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.

You could unselect 'Truncate' in the table properties.

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.

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.