CMS and Audit Database on SQL server or oracle

security CMC
1

Hi,

We currently have BOXIR2 SP4 and we are in process or migration to XI3.1

the current DB is MY SQL .IN XI3.1 we need to create the CMS and Audit DB on SQL server or on oracle .

How can we do this please guide me with steps needed to achieve this.

what are the initial configurations needed ie dsn to oracle , sql server

please let me know how to do this

amruta (BOB member since 2007-04-24)

2

What is your exact need? Is it to move from Mysql to Oracle or SQL Server the cureent CMS/audit database?

3

What i exactly need is :

  1. after i install xi3.1 on teh new server i will have to configure the Audit and CMS dB on this new server . i need to know how i can do it on oracle and sql server . i am asking both because i still dont know which would be used .

I havent installed or configured cms and audit on any other db except mysql whic is deafult.

so once i configure new server on let say oracle then after i migrate everything will go to these DB ie CMS Audit only.

I hope i am clear .

So the bottom line is how can one point the CMS and Audit Db of BO to oracle or Sql Server in case of new install .

( is it just select other Db and point it by creating a dsn ?? )

amruta (BOB member since 2007-04-24)

4

Correct

First create your DSN (more precisely 2 is better since you must not store the audit stuff and the cms stuff within the same db) and while running the fresh install instead of mysql specify your db info like schema/instance name …

5

how to do it for oracle ?

for sql server we can create dsn from admin tools–data surces --odbc but for oracle we cant have dsn

can you please tell me what is step for oralce

amruta (BOB member since 2007-04-24)

6

If you are not using the default MySQL installation, you should create the databases (SQL Server) or schemas (Oracle) in advance of doing the installation. Once the databases are created (whether on the same machine as BusObj or not), create the DSNs (SQL Server) or TNSNAMES.ORA file (Oracle) entries, and independently test the connectivity. Only AFTER you know the connections are working, then begin your BusObj install. Specifying the SQL Server / Oracle items during install is rather straightforward at that point, and outlined clearly in the install guide.

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

7

Thanks for the reply

i am planning to migrate current xir2 to xi3.1 hence i would be configuring the xi3.1 machine first and run import wizard from this new machine.

would the current audit and cms db directly go into the new machines audit and cms or i have to seperately copy them in the new databases?

what is the way to get the existing DB ie CMS and Audit in XI3.1 please let me know.

amruta (BOB member since 2007-04-24)

8

Import Wizard will take care of the CMS database but for audit database, you will have to manually copy it to XI 3.x. I read somewhere that the db structure for audit db is changed in XI3.x so be careful with that.

zack :us: (BOB member since 2007-08-02)