Red Gate forums :: View topic - aspnet_Membership - no rows generated
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

aspnet_Membership - no rows generated

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



Joined: 06 Nov 2004
Posts: 4
Location: Pasadena, CA

PostPosted: Mon Aug 17, 2009 3:51 pm    Post subject: aspnet_Membership - no rows generated Reply with quote

I am trying to generate membership data for an asp.net application. The site uses the standard aspnet_users and aspnet_membership tables that both have a primary key = userID that is a uniqueidentifier.

When I run SQL Data Generator, the records in the aspnet_users table are generated but no data is generated for the aspnet_membership table. The tool reports: "Generation stopped: The generator for column UserId could not generate any more values. Rows inserted: 0". The UserId field is set to use the Foreign Key Generator.

This is my first use of Data Generator so I am sure I am just missing something.

Any thoughts?

Thanks
ROB
Back to top
View user's profile Send private message
rbanning



Joined: 06 Nov 2004
Posts: 4
Location: Pasadena, CA

PostPosted: Mon Aug 17, 2009 4:27 pm    Post subject: Solved Reply with quote

Looks like the problem was a table that was referencing the data in the aspnet_membership table. Once the relationship was removed, the data generator worked as intended.

Cheers,
ROB
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