Red Gate forums :: View topic - Open Generator Project when no database exists
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

Open Generator Project when no database exists

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



Joined: 25 Oct 2007
Posts: 11

PostPosted: Sun Nov 21, 2010 3:38 pm    Post subject: Open Generator Project when no database exists Reply with quote

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?

thanks,
Dan
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Mon Nov 22, 2010 4:44 pm    Post subject: Reply with quote

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.
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