Set delete option off for many tables?
davidf
Posts: 8 New member
three questions
1
i have many tables to populate, but the system defaults to delete old data. how can i untick the delete before generation option for multiple tables?
2
How can i set a value for a particular column in every table, without having to going into each table. for example, every table has a column called entity status and its value must be between 0 and 4, randomly. how can i universally set the conditions for this column in each of my many tables?
3
I have a database with one record in it, how can i clone this record (with all its associated dependency tables) into a new database, or even the same database, so that i have a db with the correct volumes. obviously the unique keys will increment etc.
1
i have many tables to populate, but the system defaults to delete old data. how can i untick the delete before generation option for multiple tables?
2
How can i set a value for a particular column in every table, without having to going into each table. for example, every table has a column called entity status and its value must be between 0 and 4, randomly. how can i universally set the conditions for this column in each of my many tables?
3
I have a database with one record in it, how can i clone this record (with all its associated dependency tables) into a new database, or even the same database, so that i have a db with the correct volumes. obviously the unique keys will increment etc.
Tagged:
Answers
Thanks for your questions.
While I can see those features would be very helpful, I'm afraid they are not something you could do within SQL Data Generator at the moment. I'll raise them as feature requests with the product team.
We are very sorry for the lack of support for those features for the time being.
Tianjiao Li | Redgate Software
Have you visited our Help Center?