Centrify

Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >
article

KB-7693: How to Migrate Custom Reports from SQL express

Authentication Service ,  

27 October,16 at 11:49 PM

Applies to: Centrify DirectControl 5.3.1 and below.

Question:
If a Centrfiy Report Services customer creates custom reports using the included SQL Server 2008 R2 Express Edition and then decides to migrate to use a production SQL Server, what needs to be done to migrate the custom reports?

Answer:
Please follow below steps:
1. Create a temporary folder on your local computer to temporarily store all the downloaded custom reports.
2. Use Internet Explorer to open "Centrify Report Services"
3. Go into "Custom Reports" folder.
4. Select a report and click "Download..." to Download and save the report to the temporary folder created in step
     - Do this for all the reports. 
5. Exit from Internet Explorer.
6. Run the Centrify Report Services Configuration Wizard to choose to use an existing SQL Server instance. Specify the new SQL Server instance that you want to use and select to Deploy Centrify Reports. 
7. Use Internet Explorer to open "Centrify Report Services" again.
8. Go into the "Custom Reports" folder.
9. Click "Upload File" in toolbar to upload the report files downloaded in step 4.
10. For each uploaded report, 
a. Select and click "Manage"->"Data Sources"
b. Select the radio button "A shared data source"
c. Click the "Browse" 
d. Expand the folder "Centrify Report Services"
e. Select the item "ReportDataSource"
f. Click OK
g. Click "Apply" in the "Data Sources" page.

Related Articles

 articleKB-2727: How to migrate SQL databases associated with a Centrify_DirectManage Audit installation from one database server to another articleKB-8942: What are the steps to migrate a RHEL Brightstore cluster to Centrify articleKB-20210: Common Questions Regarding Centrify DirectControl and CoreOS articleKB-6056: How to report the group policy settings that are in effect for the local computer? article[LABS] Setup and test the Centrify Reports feature of Server Suite 2016 articleKB-6041: How to show current license type in use by adclient articleKB-6040: How to change the license type in use after adclient successful joined to the AD? articleKB-7555: Unable to login as root after upgrade to Centrify Suite 2016 (CDC 5.3.0) articleKB-6073: How to join the Linux/Unix Centrify Server to Active Directory with specific Computer Role?