MySQL(BOJCMS, BOAUDIT and BOPM) to Sybase migration issue

server administration XI Server Discussion
1

Hi,

We are in the process of migrating repository from BOXIR2 SP2 from default MySQL to Sybase database. In BO there are three databases boe115(for CMS), boe115_audit(for audit) and mysql (may be BO system info). Now we have requested the Sybase DBA’s to create three databases for BOJCMS, BOAUDIT and BOPM(Performance Mangement).

We need clarifications on two things::

  1. I have stopped cms in CCM and using CMS Database setup, tried to give the source as boe115 (i.e) and target as Sybase. But the issue is it is asking for Sybase Database Servername and login/passwd. DBA’s are concerned like it may copy to somewhere in the server as it is not asking for New schema name(BOJCMS) created for this purpose.

  2. Keeping the above issue other option is we have taken MySQL dump. If we send them this .sql script they can manually execute the script in respective schema. But here where will they execute the script from mysql database? We have only cms,audit and PM schemas created for this purpose.

Any help will be greatly appreciated.
Thanks in advance.

kch :us: (BOB member since 2005-04-08)

2

Your DBA will need to give you an account that has full control over the schema you are using. Enter that account information when prompted for the database credentials.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

3

Yes Michel, DBA has given access to the login. But for Sybase in CMS Database setup, it is asking login credentials for Sybase Database Server Name, login and password. No where it is asking info about the newly created schema for CMS in Sybase…
So, DBA’s concern is that it may copy the data in the Syabse’s Master data scope rather than the newly created schema for CMS.

kch :us: (BOB member since 2005-04-08)

4

Refer the installation guide for XIR2 page 84. It specifically says with Sybase, “you do not enter the database name. BOE uses the Sybase service name, which specifies which machine and port the database server is on, and the default database name associated with the users profile” - this is for CMS. I suppose it treats audit and PM DB differently but you should be able to do those after you have done with CMS.

newgun :us: (BOB member since 2007-08-01)

5

For the server name, enter the middleware (DSEdit) entry for that connection. It will contain the schema information.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)