How do I setup project to point to another database?

[sgehret]

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

[Manfred.Castro]

You can open the .sqlgen file in notepad and perform a find and replace for the database.
_________________
Manfred Castro
Product Support
Red Gate Software

[sgehret]

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

[Manfred.Castro]

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

[sgehret]

Hi,

Thanks very much.

Scott