Can't edit project properties if Database connection is down

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Can't edit project properties if Database connection is down

Postby jcooke » Tue Mar 17, 2009 2:44 pm

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]
jcooke
 
Posts: 5
Joined: Tue Jan 27, 2009 9:30 pm
Location: Richmond, VA

Postby Linda Hawksworth » Thu Mar 19, 2009 4:22 pm

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.
Linda Hawksworth
 
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am

Postby jcooke » Mon Mar 23, 2009 7:47 pm

Thanks Linda...That did the trick.
jcooke
 
Posts: 5
Joined: Tue Jan 27, 2009 9:30 pm
Location: Richmond, VA


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests