Scrubber?

[rszymanski]

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.

[Linda Hawksworth]

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

http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Data%20Generator&c=SQL_Data_Generator%5carticles%5cCleansing_Data.htm

Let me know if you need any further assistance.

[rszymanski]

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?