Scrubber?

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Scrubber?

Postby rszymanski » Fri Sep 18, 2009 8:24 pm

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.
rszymanski
 
Posts: 4
Joined: Tue Jun 26, 2007 8:07 pm

Postby Linda Hawksworth » Mon Sep 21, 2009 9:55 am

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.
Linda Hawksworth
 
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am

Populate new column based on two existing columns

Postby rszymanski » Tue Nov 10, 2009 7:47 pm

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?
rszymanski
 
Posts: 4
Joined: Tue Jun 26, 2007 8:07 pm


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests