1876557 - How to use Copy Data from another Data Source in Crystal Server 2008 Environment

This article can be applied to the following scenarios:

• You have a production CR Server 2008 environment and you want to create a User Acceptance Testing (UAT) environment using the production CMS database
• If your existing CMS database is corrupted, you can copy data from another existing environment's CMS database

Disclaimer: Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

In this article, we refer to production environment as "Source", UAT environment as "Destination".

Production Environment:

• Single Server
• Crystal Server 2008 V1 SP3
• Operating System: Windows 2008 R2 32bit
• CMS Database: Oracle 10g (on an external server)
• Auditing Database: Oracle 10g (on an external server)
• Oracle 10g Client
• Application Server: Tomcat 5.5

UAT Environment:

• Single Server
• Crystal Server 2008 V1 SP3
• Operating System: Windows 2008 R2 32bit
• Current CMS Database: MySQL (on local server)
• Auditing Database: MySQL (on local server)
• Target CMS Database: Oracle 11g (on an external server)
• Target Auditing Database: Oracle 11g (on an external server)
• Oracle 11g Client
• Application Server: Tomcat 5.5

crystal server 2008 v1 sp3 businessobjects XI 3.1 clone copy replication duplicate backup back up mirror database cms windows oracle mysql production user acceptance testing UAT environment , KBA , BI-BIP-SRV , CMS / Auditing issues (excl. 3rd Party Authentication) , How To