Change in schema name of DB

Posts   
 
    
shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 02-Jun-2011 06:51:57   

DB: Oracle 9i/10g MSORACLE LLBLGEN 3.1 Release 20-May-2011 .NET Framework 2.0 Windows App

Hi

I am now almost done with development of project over an year. All the way during my development I used DB name BCLUB1868 and now in production i have changed to BCLUB2011.

What changes I need to make in designer so that I can refresh the catalog and regenerate the code for my production DB?

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 02-Jun-2011 11:28:47   

You don't have to regenerate for the production db. it's just a configuration change.

Check this: Schema name overwriting

shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 02-Jun-2011 11:50:22   

Walaa wrote:

You don't have to regenerate for the production db. it's just a configuration change.

Check this: Schema name overwriting

This is fine. But now on, i would like to use the production DB to add or modify entities. So what change I need to make in designer to point to new DB? since the user and pwd is different

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 02-Jun-2011 12:25:43   

Just refresh the catalog, and there you will be prompted to enter the Server name, user name and password.

And proceed from there.

shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 02-Jun-2011 12:26:28   

Walaa wrote:

Just refresh the catalog, and there you will be prompted to enter the Server name, user name and password.

And proceed from there.

Thanks