How can we help you today? How can we help you today?

How do I setup project to point to another database?

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
sgehret
0

Comments

4 comments

Sort by
  • Manfred.Castro
    You can open the .sqlgen file in notepad and perform a find and replace for the database.
    Manfred.Castro
    0
  • 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
    sgehret
    0
  • 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
    0
  • sgehret
    Hi,

    Thanks very much.

    Scott
    sgehret
    0

Add comment

Please sign in to leave a comment.