Creating email address

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Creating email address

Postby dineshasanka » Wed Apr 16, 2008 1:47 pm

I had few issues with creating email addresses. I set ($[FirstName])(.)($[Lastname])@(somewhere.com) regular expression to the email address. I cannot set unique column on to email and it gives me error message saying that it cannot generate enough data. I am sure that data length and uniqueness is not an issue.

Also, if I removed the unique option it will generate only 969 records and failed mid of data generation due to unknown reason.
dineshasanka
 
Posts: 133
Joined: Mon Jul 11, 2005 1:04 pm
Location: Colombo Sri Lanka

Postby benhall » Wed Apr 16, 2008 3:05 pm

Hi Dinesh,

Thanks for the comments.

The first issue with regard to uniqueness is a current limitation within the software. Sadly, we do not support an inter column relationship and uniqueness for RegEx, as in your example. We are aware of this, however I am not sure at the moment that this will be fixed in 1.1. Do you feel this is an important feature?

However, I am not sure why it is only generating 969 rows. It could be that the data being generated is too large for your column? By default, "When data is invalid" we skip the row, this is set on the table generation settings screen. If you change this to truncate data, are 1000 rows generated?

I look forward to hearing your response.

Thanks

Ben
benhall
 
Posts: 69
Joined: Fri Dec 14, 2007 11:15 am


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests