Red Gate forums :: View topic - Can't edit project properties if Database connection is down
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

Can't edit project properties if Database connection is down

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



Joined: 27 Jan 2009
Posts: 5
Location: Richmond, VA

PostPosted: Tue Mar 17, 2009 2:44 pm    Post subject: Can't edit project properties if Database connection is down Reply with quote

Hi,

I had set up a number of generator projects pointing to a particular database. The machine that housed the database needed to be rebuilt. After they started the rebuild, I was going to load my data to a different database.
The problem is that when I try to open the project to change the DB connection, I get an error that says that the project could not be loaded due to the fact that it could not connect to the database.
Is there anyway to change the project connection properties outside the GUI?

Thanks
Jim Cooke[/img]
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Thu Mar 19, 2009 4:22 pm    Post subject: Reply with quote

You can manually edit the project file (*.sqlgen) in Notepad and change the server name and/or database name. Look for the string:

<ServerName>LINDA\SQLSERVER2000</ServerName><DatabaseName>WidgetDev</DatabaseName>

Please let me know if this works for you.
Back to top
View user's profile Send private message
jcooke



Joined: 27 Jan 2009
Posts: 5
Location: Richmond, VA

PostPosted: Mon Mar 23, 2009 7:47 pm    Post subject: Reply with quote

Thanks Linda...That did the trick.
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