I was hoping this day wouldn't come....the project I was previously on deployed to a government application hosting facility that I am convinced is operated by poorly trained monkeys who insisted on changing all 600 of our table/column names according to cryptic data standards naming conventions--i.e. a column named "Comments" would be changed to "RMK_DE_DEF_TX". Lovely, except this meant nothing whatsoever in the context of our application, so I changed all the field names in LLBLGen Pro project to reflect their actual meaning in our app code. Why is this relevant? Because now the DBAs there want to upgrade their database instances to 10g. Of course they do. So this means I have to create a new project. The question is: is there any easy way of doing this? Is manually duplicating the 8i/9i project to the new 10g project the only way?

It's only a driver mapping you need to get changed.

I'd suggest to you to download the sourcecode of the command line project refresher tool from the extras section. Take that sourcecode and you'll see how to load a project and map the driver into the project. What you then do is map the 10g driver into the project and save it again. That should be it. Keep a backup of your project if something goes wrong. If you need help or it doesn't work, let me know.

Thanks, I will try that out. Will you by chance be building the capability to switch a project's targeted driver in a future version of the designer?

By the way, EXCELLENT job on the latest version of the tool--hats off!

jookyone wrote:

Thanks, I will try that out. Will you by chance be building the capability to switch a project's targeted driver in a future version of the designer?

A converter app is in its final stages. That converter will convert a .lgp project to a different db type. In the future that code will likely be merged with the designer, but that's still undecided, as it's not a common task.

By the way, EXCELLENT job on the latest version of the tool--hats off!

Thanks!