Chat now with support
Chat with Support

Enterprise Reporter 3.2.1 - Installation and Deployment Guide

Product Overview Installation Considerations for Enterprise Reporter Installing and Configuring Enterprise Reporter Managing Your Enterprise Reporter Deployment Troubleshooting Issues with Enterprise Reporter Appendix: Database Content Wizard Appendix: Encryption Key Manager Appendix: Log Viewer

Appendix: Database Content Wizard

•
Software Requirements
•
Starting and Configuring the Enterprise Reporter Database Content Wizard
•
Transferring an Enterprise Reporter Database
•
Backing Up an Enterprise Reporter Database
•
Restoring an Enterprise Reporter Database
•
Cleaning an Enterprise Reporter Database
•
Merging Two Enterprise Reporter Databases
•
Running Custom Enterprise Reporter Scripts

The Enterprise Reporter Database Content Wizard can be started from the Windows Start menu or from within the main Database Wizard. The Enterprise Reporter Database Content Wizard allows you to perform the following tasks on the information stored in Enterprise Reporter SQL Server® Databases:

•
Configuration information (Clusters and Nodes, Discoveries, and Reports)
•
Transfer
•
Backup
•
Restore
•
Collected data
•
Clean
•
Merge
•
Custom scripts

Software Requirements

•
PowerShell® 3.0

Starting and Configuring the Enterprise Reporter Database Content Wizard

To start and configure the Enterprise Reporter Database Content Wizard
1
Start the main Database Wizard by clicking the Start menu, and select All Programs | Quest | Enterprise Reporter | Database Content Wizard.
2
Optionally, click Advanced Settings to configure how long the server will wait for a response.
3
Optionally, set the SQL Server Connection Timeout.
4
Optionally, set the SQL Server Command Timeout.
5
Optionally, click Reset to defaults to restore both timeouts to 60 seconds.
6
Click OK.

Transferring an Enterprise Reporter Database

The transfer task allows the transfer of configuration data (Cluster, Node, Discovery, and Report information) between two Enterprise Reporter SQL Server® databases of the same version. This is useful for new Enterprise Reporter installations when Cluster, Node, Discovery, and Report information has already been configured.

* 
NOTE: Collected data is not included in the transfer process.
To transfer an Enterprise Reporter database, complete the following steps:
1
Define the source database information.
2
Define the target database information.
3
Choose the data to transfer.
To define the source database information
1
Click Transfer.
2
Click Define source database information.
3
Enter the Source SQL Server name.
- OR -
Click the ellipsis to enumerate all broadcasting SQL Servers on the network and select one.
4
Enter the Source database name.
- OR -
Click the ellipsis to select a database from the specified Source SQL Server.
5
Select an authentication method.
6
If SQL Server authentication was selected, enter the credentials.
7
Click OK.
To define the target database information
1
After defining the source database information, click Define target database information.
2
Enter the Target SQL Server name.
- OR -
Click the ellipsis to enumerate all broadcasting SQL Servers on the network and select one.
3
Enter the Target database name.
- OR -
Click the ellipsis to select a database from the specified Target SQL Server.
4
Select an authentication method.
5
If SQL Server authentication was selected, enter the credentials.
6
Click OK.
To choose the data to transfer
1
After defining the target database information, click Choose data to transfer.
2
Select the elements to transfer.
* 
NOTE: Clearing the Clusters and Nodes option will remove the association between discoveries and clusters/nodes. They will need to be reconfigured manually.
3
If you have cleared the Clusters and Nodes option, click Yes to accept the warning and continue.
4
Click Run.
* 
CAUTION: After the data transfer has completed successfully, you must restart your Enterprise Reporter Server service.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating