Creating email address

The simplest way to populate your database with test data.

Creating email address

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

I had few issues with creating email addresses. I set ($[FirstName])(.)($[Lastname])@( 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.
Posts: 133
Joined: Mon Jul 11, 2005 12:04 pm
Location: Colombo Sri Lanka

Postby benhall » Wed Apr 16, 2008 2: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.


Posts: 69
Joined: Fri Dec 14, 2007 10:15 am

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests