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

Scrubber?

rszymanskirszymanski Posts: 6
I have the need to scrub existing data in a SQL Server 2005 database.
Will the SQL Data Generator allow me to keep certain fields in a pre-populated table and delete/truncate and subsequently generate in others?

Thanks in advance.

Comments

  • Options
    Yes - this is entirely possible. Please see the following knowledgebase article:

    http://www.red-gate.com/supportcenter/C ... g_Data.htm

    Let me know if you need any further assistance.
  • Options
    Works great. Thanks.

    I do have another question. Is it possible to use a Regular Expression on existing fields using an existing table name field?

    Here is what I'm trying to do: I have an existing column called NAME which contains the Last, First name generated by the generator. I also have a column called SSN which is also populated by the generator. I have a requirement to populate a third columns which is a combination of the two called LNI_SSN where LNI is the last name initial followed by the last 4 digits of the SSN.

    For example:
    NAME = Bush, Carla
    SSN = 012345678
    LNI_SSN = B5678

    My question is, how can I do this? Can I use regular expressions?

    Thanks in advance?
Sign In or Register to comment.