Red Gate forums :: View topic - Scrubber?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

Scrubber?

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
rszymanski



Joined: 26 Jun 2007
Posts: 4

PostPosted: Fri Sep 18, 2009 8:24 pm    Post subject: Scrubber? Reply with quote

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.
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Mon Sep 21, 2009 9:55 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
rszymanski



Joined: 26 Jun 2007
Posts: 4

PostPosted: Tue Nov 10, 2009 7:47 pm    Post subject: Populate new column based on two existing columns Reply with quote

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?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group