Pointing to a different Oracle Schema

Posts   
 
    
grjoseph
User
Posts: 7
Joined: 03-Mar-2010
# Posted on: 15-Mar-2010 21:50:04   

Hello,

I looked through some for the forums and can't see what I am looking for. I created a project that points to a schema with this name: TestDB1

but I now want to point that to the TestDB2 schema.

I looked in the documentation and I see this but don't understand how it works.

<configSections> <section name="oracleSchemaNameOverwrites" type="System.Configuration.NameValueSectionHandler" /> </configSections>

<oracleSchemaNameOverwrites> <add key="SCOTT" value="HR" /> </oracleSchemaNameOverwrites>

this is my current connection string.

<appSettings> <add key="Oracle.ConnectionString" value="data source=dummy-data;user id=TestDB1;password=TestDB1;persist security info=false;"/> <add key="OracleTriggerSequences" value="true" /> </appSettings>

any pointers?

thanks all.

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 16-Mar-2010 02:42:06   

What is your old schema and your new one?

You also can make the new schema empty and LLBLGen will take the one specified in you connection string. For more information read Schema name overwriting.

Maybe you already read that, so please tell us what is the specific problem you are facing, and if that is the case please post the LLBLGen version and runtime library version (http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7722).

David Elizondo | LLBLGen Support Team