What are the challenges you face when working across database platforms? Take the survey
Options

Set delete option off for many tables?

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.

Tagged:

Answers

  • Options
    Hi @davidf

    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.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.