The simplest way to populate your database with test data.
Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr
I'm trying to create a large database (50 gigs) for testing purposes. I can't seem to get one particular table to load. It will hang at 0%, 10% and now 100%. I think it depends on how many records I'm trying to generate. At 1.5 million it hangs at 0%. I let it run for 12 hours and it didn't seem to do anything. At 1000 rows it's hanging at 100%. At 100 it succeeds. There is a unique non-clustered index that I thought would help to drop but it's being used by other tables for foreign key constraints so I can not drop it. I've successfully generated a 5 gig database but I'm stuck trying to generate this larger one. BTW, "Cancelling" never works.
- Posts: 5
- Joined: Wed Jun 26, 2013 7:36 pm
- Location: Olympia, WA
I think we may have to get back you by email on this one. Obviously data generation times depend on the types of generators and the database schema (maybe triggers are running during the update). Having the cancel button not responding is a bit worrying though.
- Posts: 6670
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Data Generator 2
Who is online
Users browsing this forum: No registered users and 1 guest