Red Gate forums :: View topic - We are looking for feedback about version 1.0
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

We are looking for feedback about version 1.0

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



Joined: 16 Dec 2005
Posts: 170

PostPosted: Mon Mar 31, 2008 6:25 pm    Post subject: We are looking for feedback about version 1.0 Reply with quote

First I would like to thank all the people who provided feedback on the SQL Data Generator Beta. It really helped us a huge amount in producing the product.

We still looking to improve the product further so we would love to hear from anyone who has tried out version 1.0. If you would be willing to give us some feedback over the phone or by email then please send me a message by clicking on the pm button at the bottom of the page. Thanks

Lionel
_________________
Software Engineer
Red Gate Software
Back to top
View user's profile Send private message
colinangusmackay



Joined: 01 Apr 2008
Posts: 3
Location: Scotland

PostPosted: Tue Apr 01, 2008 12:58 am    Post subject: Feedback (first impressions) Reply with quote

First off, I realised it is a version 1.0 and while it is excellent at what it does I have some feature requests.

So, the plus points, because I was very impressed with it. It is fast at generating the data. It is easy to use, the user interface is very intuitive (if there is a help file Iíve not needed it yet). I love the creation of business names.

Now, the feature requests:
Mostly, Iíd like to be able to make the data look more realistic.

For example, my test database was a for a tenant referencing system. The salary column can contain values from 5K to 200K (typically), but the random generation means that there is an even spread, while in reality it is a bell curve with most of the values concentrated rougly in the 15K to 25K range. A similar thing happens with the rent amount.

Another example would be that there are rules about whether a guarantor is needed, for example if the rent exceeds a certain percentage of salary (it is actually more complex than that, but for creating test data it will suffice) so even although I can set a percentage of nulls on the GuarantorId foreign key column it doesnít necessarily come close to reality. E.g. a person renting a property for £350 per month, but with a 150K salary, does not generally need a guarantor.

A similar scenario happens with deposit vs. rent. Typically a deposit is not wildly different from the monthly rent. So, some way of creating rules for one column based on the value created for another would be great.

Those are my initial impressions, I've only been playing around with it for a short while. I hope the above is useful.
Back to top
View user's profile Send private message
Lionel



Joined: 16 Dec 2005
Posts: 170

PostPosted: Tue Apr 01, 2008 7:18 pm    Post subject: Reply with quote

Thanks a lot for the feedback. Both those feature seem like excellent ideas.

We have some ideas about how to do the distribution feature but I am really interested in how you would like it to work. Would you like to be able to choose from a variaty of existing distributions and specify the params say choose a normal distribution and change the min, max, variance and average values or would you prefer to be able to define your own curve? Also would you like to make the distribution as the distribution of some data in an existing column?

Being able to choose a generator based on a columns value is another feature that a few people have asked for. Would you like to have some GUI where you say use a particular generator if a column was one value and another generator if it was another value? Would you rather we had some simple little expression language based around SQL so you could specify the value based using case statement?

By the way of you vist the codeplex site http://www.codeplex.com/SDGGenerators We have made some UK address generators available for download which you might find useful. Sorry for all the questions and thanks again for the feedback.

Lionel
_________________
Software Engineer
Red Gate Software
Back to top
View user's profile Send private message
KeeperOfTheSoul



Joined: 11 Jan 2008
Posts: 4

PostPosted: Wed Oct 22, 2008 10:46 am    Post subject: Reply with quote

I try to avoid using null in the database for text based columns preferring to use a blank string instead so an "Allow blank values" option for char, nchar, varchar and nvarchar types would be useful.

This would work in the same way as the "Allow null values" option.

Also when generating emails addresses, would be nice to be able to use the permutations of the generated forename / surname columns.
Back to top
View user's profile Send private message
KeeperOfTheSoul



Joined: 11 Jan 2008
Posts: 4

PostPosted: Wed Oct 22, 2008 11:08 am    Post subject: Reply with quote

Would be nice if regexes could be set to ignore white space so I could break complex ones into multiple lines and add comments

This is the regex I use to get a good mix of emails
Code:
((($[forename][._]?)?$[surname]|$[forename]([._]?$[surname])?)([0-9]{0,3})?|[a-z]{4,8}([0-9]{0,3}|\.[a-z]{4,10}))@example.com


Would be nicer if it were wrote
Code:
(
  (?# Generate forname/surname pairs with a possible separator )
  (
   (?# optional forename, optional surname )
   ($[forename][._]?)?$[surname]

   (?# non-optional forename, optional surname )
   |$[forename]([._]?$[surname])?
  )([0-9]{0,3})? (?# Sometimes add a numerix suffix to the forename/surname pair )
   
  (?# Throw a few random ones into the mix )
  |[a-z]{4,8}([0-9]{0,3}|\.[a-z]{4,10})

)@example.com
Back to top
View user's profile Send private message
scifigooner



Joined: 04 Nov 2008
Posts: 1

PostPosted: Tue Nov 04, 2008 6:17 pm    Post subject: Reply with quote

I would like to use the generator to modify certain fields in a database which contain sensitive data, but leave everything else the same.

Currently the generator only seems to be able to modify all the fields in the database.
Back to top
View user's profile Send private message
PDav



Joined: 19 Feb 2009
Posts: 2
Location: WA

PostPosted: Thu Feb 19, 2009 11:49 pm    Post subject: Please allow option to use or to NOT use the Delete Data opt Reply with quote

Data Deletion Option
I have over 450 tables. It was a major pain to go to each one and uncheck the Delete Data option on each one.

Please simply make it a global option.

It is easy enough for anyone to write a simple script to drop FKs, truncate all or just some data, and add back the FKs.

In scenarios with just a few tables, I might use the table-level option, but for most of my current needs, I want to handle the data deletion outside of the data generation and I do not want to suffer through table-level choices for that.

Data Generation Errors
Please consider allowing any errors to be logged to the System Log.

Thanks.
Back to top
View user's profile Send private message
PDav



Joined: 19 Feb 2009
Posts: 2
Location: WA

PostPosted: Fri Feb 20, 2009 12:31 am    Post subject: Data Source Option in 1.2 Reply with quote

Both this and the response above it are actually for Data Generator 1.2

Please change the Data Source Option so that I don't need to specify the database at the table level. Make it so the database can be changed with the assumption that the table name is the same in whatever database is specified.

I now have the ugly task of modifying 138 table sources.
Help.

Thanks
Back to top
View user's profile Send private message
steve@powell.net



Joined: 16 Sep 2009
Posts: 5

PostPosted: Wed Sep 16, 2009 1:28 pm    Post subject: Feature Reqests Reply with quote

A couple of simple generators

Date Of Birth (Just date no Time portion) in a suitable range, it would be nice if this could be weighted to bunch people in a grouping/curve.

What about column shuffle. It takes all the data in the table and just shuffles each columns contents.

We can run extracts out of our live systems with user data in them. We then like to shuffle the name and address columns. The US adresses you guys provide don't work to well over here in the UK and don't get me started on the differences between ZIP codes and UK postcodes.

This also weights our date of births accordingly. Which means our metrics don't end up wildly different to the actual data.
Back to top
View user's profile Send private message
pgrant99



Joined: 26 Apr 2011
Posts: 1
Location: USA

PostPosted: Tue Apr 26, 2011 10:37 pm    Post subject: Response to PDav about changing the database name Reply with quote

This is in response to PDav's post:

The config file for SQL Data Generator is XML, and you can simply close SDG and edit the xml file, changing the database name, save it and then reopen SDG.

Worked like a charm for me.

Very Happy

Phillip
Back to top
View user's profile Send private message
kevine323



Joined: 27 Jul 2006
Posts: 39

PostPosted: Fri Jun 17, 2011 5:41 pm    Post subject: Reply with quote

The ability to generate a sql script rather than using bulk import would be nice. It would allow us to modify columns if needed and monitor things such as insert time.
_________________
Kevin Eckart
Database Administrator
USA Truck, Inc
Kevin.Eckart@usa-truck.com
http://kevine323.blogspot.com/
Back to top
View user's profile Send private message Send e-mail AIM Address Yahoo Messenger
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