Red Gate forums :: View topic - Creating email address
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

Creating email address

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



Joined: 11 Jul 2005
Posts: 166
Location: Colombo Sri Lanka

PostPosted: Wed Apr 16, 2008 1:47 pm    Post subject: Creating email address Reply with quote

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.
Back to top
View user's profile Send private message Send e-mail AIM Address Yahoo Messenger MSN Messenger
benhall



Joined: 14 Dec 2007
Posts: 98

PostPosted: Wed Apr 16, 2008 3:05 pm    Post subject: Reply with quote

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