The simplest way to populate your database with test data.
Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr
I used data generator to generate some data, then wanted to restore my database to its original state. This requires exclusive access to the database, but it appears that the SQL Generator app holds its database connection, even if you close the project it still seems live until you close the whole application.
Closing and reopening the app is a work around, but is there something more obvious?
- Posts: 1
- Joined: Thu Apr 04, 2013 7:11 am
Thanks for your post.
Which version of SQL Server are you using? This doesn't appear to happen when I tested it with SQL 2008 and SQL 2012.
Are you restoring using native SQL or something else?
What does sp_who2 show you for the connection to the database you're trying to restore?
- Posts: 757
- Joined: Tue Oct 24, 2006 2:12 pm
- Location: Red Gate Software Ltd.
Return to SQL Data Generator 2
Who is online
Users browsing this forum: No registered users and 0 guests