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

Data Generation Question

gsuttiegsuttie Posts: 80
Is there any way to take an existing table and then have it ignore say the primary key column and have the tool generate new data for existing rows.

We have some rubbish test data in a table - really long surnames and phone numbers which are garbage and Id like to generate some clean data which has actual names and proper phone numbers.

Is this possible ? or can you suggest a way to clean the data?

Thanks
Gregor

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post.

    What type of Primary column is it? I mean data type? Is it an Identity seed?

    You can clean the existing data by selecting the option 'Delete data from table before generation'.

    When you choose to delete the data from the table before generation, if possible SQL Data Generator truncates the table to remove all the existing rows before re-populating the table.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    Hi,

    The primary key is a uniqueidentifier - I don't actually want to delete the data id rather like to say grab the surname columns and have the tool generate new surnames for the rows I have selected - that really would make the data generation powerful.

    Cheers
    Gregor
  • Options
    Anu DAnu D Posts: 876 Silver 3
    I have emailed you asking for the details.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    Hi all,

    I have a question similar to some others I've seen on the forums.

    I'm trying to load a table with data (call it table E) that must have a matching record in a different table (P). Unfortunately, the unique identifier in P is a composite key between 2 columns (for example, ID & Company).

    At first I thought I'd do a simple lookup using the SQL statement generator - select statement, just make sure I was grabbing 2 valid answers for each column, generate data, and then address the errors with my other db tool. Unfortunately, after generating 100k records I only ended up with 7 that match... that's too many errors for my other tool.

    How can I pull a composite key out of table P and use it to populate table E so that my generated data in E will match a real record in P?
    Thanks
Sign In or Register to comment.