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.
Automatic Min Value for Sequential Data Generator
-
- Posts: 24
- Joined: Thu 21 Dec 2006 08:45
- Location: Portland, OR
- Contact:
Re: Automatic Min Value for Sequential Data Generator
You could unselect 'Truncate' in the table properties.
-
- Posts: 24
- Joined: Thu 21 Dec 2006 08:45
- Location: Portland, OR
- Contact:
Re: Automatic Min Value for Sequential Data Generator
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.
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.
Re: Automatic Min Value for Sequential Data Generator
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.
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.