Red Gate forums :: View topic - Data Generation Question
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

Data Generation Question

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



Joined: 30 Nov 2005
Posts: 45
Location: Glasgow, Scotland

PostPosted: Fri Feb 26, 2010 9:37 am    Post subject: Data Generation Question Reply with quote

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



Joined: 20 Apr 2009
Posts: 688
Location: Cambridge

PostPosted: Mon Mar 01, 2010 1:55 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
gsuttie



Joined: 30 Nov 2005
Posts: 45
Location: Glasgow, Scotland

PostPosted: Mon Mar 01, 2010 2:45 pm    Post subject: Reply Reply with quote

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



Joined: 20 Apr 2009
Posts: 688
Location: Cambridge

PostPosted: Tue Mar 02, 2010 10:28 am    Post subject: Reply with quote

I have emailed you asking for the details.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
great49er



Joined: 02 Mar 2010
Posts: 1

PostPosted: Tue Mar 02, 2010 10:56 pm    Post subject: Matching Composite Keys? Reply with quote

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
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