BusinessObjects Board

create two repository on the same server for full client

security Supervisor (4.x - 6.x)
#1

HI, everyone, I need help. We are using businessobjects 5.1 full client. We are trying to create testing repository and production repository on the same database. Is it possible to create two different repository on the same server or has to be on different server?

thanks for any help or suggestion. :lol:

lavinaluo (BOB member since 2005-02-14)

#2

Yes, it is possible. The terminology differs by database (SQL Server has multiple databases, Oracle has schemas, etc.), but as long as you have a different “owner” you can have multiple domains (security, universe, and / document) on the same database server instance.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#3

Dwayne, thanks for your reply. What do you mean by different ‘Owner’ at this point? thanks

lavinaluo (BOB member since 2005-02-14)

#4

That is the ‘owner’ of the tables in the database - generally the user who created them.

For example, with SQLServer



MyDatabase.dbo.MyTable
MyDatabase.AUser.MyTable

Both tables have the same name and exist in the same database, but are owned by different users. If you create repositories using different users, they can exist in the same database.

Paul Williams :uk: (BOB member since 2002-07-10)

#5

Got you. thanks for your reply :lol:

lavinaluo (BOB member since 2005-02-14)

#6

Also, be sure to take a look at this entry on pros/cons of multiple repositories from our FAQ: Supervisor.

Anita Craig :us: (BOB member since 2002-06-17)