Red Gate forums :: View topic - How do I setup project to point to another database?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 2
SQL Data Generator 2 forum

How do I setup project to point to another database?

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sgehret



Joined: 07 Dec 2012
Posts: 7
Location: United States

PostPosted: Wed Mar 06, 2013 5:58 pm    Post subject: How do I setup project to point to another database? Reply with quote

Hi,

I know the project can be easily changed, but I have a project with dozens of embedded SQL Statements that have the database name in it. So I can point the project to another database, but I have to go into each field that does a SQL Statement and change the database name. There has to be an easier way to do this. We have the need to point the same project and run for hundreds of databases.

Thanks,
Scott
Back to top
View user's profile Send private message AIM Address
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Thu Mar 07, 2013 7:01 pm    Post subject: Reply with quote

You can open the .sqlgen file in notepad and perform a find and replace for the database.
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
sgehret



Joined: 07 Dec 2012
Posts: 7
Location: United States

PostPosted: Thu Mar 07, 2013 7:15 pm    Post subject: Reply with quote

Thanks much for the info. So I guess that means there is no way to do it from within the tool itself. Is that something that may be added later?

Thanks,
Scott
Back to top
View user's profile Send private message AIM Address
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Thu Mar 07, 2013 10:25 pm    Post subject: Reply with quote

There is no way currently to do it within the application.
I have logged a feature request for you under the internal reference number of SDG-1023
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
sgehret



Joined: 07 Dec 2012
Posts: 7
Location: United States

PostPosted: Thu Mar 07, 2013 10:26 pm    Post subject: Reply with quote

Hi,

Thanks very much.

Scott
Back to top
View user's profile Send private message AIM Address
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