BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

[XI 3.1] BO CMC/Audit Database Migration


 
Search this topic... | Search XI Server Discussion... | Search Box
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Author Message
srini2019t
Forum Member
Forum Member



Joined: 01 Mar 2019

Posts: 5



PostPosted: Fri Mar 01, 2019 12:50 pm 
Post subject: BO CMC/Audit Database Migration

Hello,

We have currently SAP BOXI 3.1 SP5 system is running CMS/Audit database on Oracle 11G Database. (Cluster BO environment)

Will it possible to migrate CMS/Audit database from Oracle 11G to SQL Server in same environment (SAP BOXI 3.1 SP5)?

If it is possible then which version of SQL Server database is suitable for Migration.

Please let me know if you have any standard BO CMS/Audit database migration doc for Oracle 11G to SQL Server DB

Also, advise me if any challenges or bottle neck issues if we do the migration?

Regards,
Srini.T
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1901
Location: Atlanta, GA


flag
PostPosted: Mon Mar 11, 2019 12:37 pm 
Post subject: Re: BO CMC/Audit Database Migration

It is possible to migrate the CMS database with few issues using the Central Configuration Manager. You just have to have an empty database schema configured for it.

I don't remember whether 3.1 let you migrate the audit database the same way or not - I know that 4.x does not.

As for SQL Server versions, 3.1 will NOT work with the newer versions of SQL Server. I suggest either 2008r2 or 2012, but you'll want to test to be sure. Also, be aware that 3.1 when out of support a couple of years ago, so you won't be able to get support from SAP for it.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
JohnBClark
Forum Enthusiast
Forum Enthusiast



Joined: 27 Mar 2007
ASUG Icon
Posts: 1027
Location: Appleton, WI USA


flag
PostPosted: Tue Mar 12, 2019 8:06 am 
Post subject: Re: BO CMC/Audit Database Migration

hilfy wrote:
I don't remember whether 3.1 let you migrate the audit database the same way or not - I know that 4.x does not.
The audit database will not migrate, only the CMS database is migrated by the Central Configuration Manager. You will have to migrate the audit database yourself.
_________________
BusinessObjects BI4.2sp4, SQL Server 2016 (CMS)
Clustered for fail over redundancy
Reporting Tools: Crystal Reports 2016sp4, Web Intelligence
Operating System: Windows 2016 running on VMWare
Reporting databases: SQL Server, Teradata, DB2, Oracle, Hive
Information Steward 4.2sp10
History: BO5, BO6, XIR2, XI3.1, BI4.1.x
Back to top
srini2019t
Forum Member
Forum Member



Joined: 01 Mar 2019

Posts: 5



PostPosted: Wed Mar 13, 2019 3:37 am 
Post subject: Re: BO CMC/Audit Database Migration

Thanks for your inputs..
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0269 seconds using 17 queries. (SQL 0.0021 Parse 0.0009 Other 0.0239)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo