aspnet_Membership - no rows generated

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

aspnet_Membership - no rows generated

Postby rbanning » Mon Aug 17, 2009 3:51 pm

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
rbanning
 
Posts: 4
Joined: Sat Nov 06, 2004 5:02 pm
Location: Pasadena, CA

Solved

Postby rbanning » Mon Aug 17, 2009 4:27 pm

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
rbanning
 
Posts: 4
Joined: Sat Nov 06, 2004 5:02 pm
Location: Pasadena, CA


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests