The simplest way to populate your database with test data.
Moderators: David Atkinson, Anu Deshpande, Lionel
I can't open a generator project if the database it was built for doesn't exist or isn't accessable. I would like to be able to point a generator project at different databases.
My workaround is to create an empty database with the name that is in the project, then change the name of the database in the project, then drop the empty one I created to get things started.
Is there an easier way to do this? Why does the database have to exist to open a generator project?
- Posts: 11
- Joined: Thu Oct 25, 2007 4:27 pm
Thanks for your post. This problem occurs because when you open a project, SDG will refresh the schema from the database. There isn't an option to disable this that I know of.
One possible workaround is that the project files are basically just XML. So you could open it up in Notepad (or a nicer editor if you have one) and amend the database name. It should then refresh the schema of the new DB you're referencing when you open the file.
- Posts: 1144
- Joined: Wed Jun 16, 2010 11:10 am
- Location: My desk.
Return to SQL Data Generator 1
Who is online
Users browsing this forum: No registered users and 0 guests