Chat now with support
Chat with Support

Enterprise Reporter 3.5.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

Merging Two Enterprise Reporter Databases

The merge task allows merging of collected data in a source Enterprise Reporter SQL Server® database into a target Enterprise Reporter SQL Server® database of the same version. The target database will contain data from both the source and target databases.

* 
NOTE: Configuration data (such as Cluster and Node, Discovery, and Report information) is not included in the merge process.
* 
CAUTION: It is strongly recommended that you back up your databases before starting the merge. You can restore the backup if there are issues with the merge.

To merge two Enterprise Reporter databases, complete the following steps:

1
Define the source database information.
2
Define the target database information.
To define the source database information
1
Click Merge.
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.
7
Click Run.
A warning is displayed indicating that the data will be permanently merged and that this action is permanent.
8
Select I understand, and click OK.

Running Custom Enterprise Reporter Scripts

The script task allows you to run custom scripts to modify the data in an Enterprise Reporter SQL Server® database. The target database will be modified based on the content of the custom script.

* 
CAUTION: It is strongly recommended that you back up your databases before starting the script. You can restore the backup if there are issues with processing the script.

To run a custom script on the Enterprise Reporter database, complete the following steps:

1
Define the target database information.
2
Select a custom script.
3
Optionally, enter script arguments.
To define the target database information
1
Click Script.
2
Click Define target database information.
3
Enter the Target SQL Server name.
- OR -
Click the ellipsis to enumerate all broadcasting SQL Servers on the network and select one.
4
Enter the Target database name.
- OR -
Click the ellipsis to select a database from the specified Target SQL Server.
5
Select an authentication method.
6
If SQL Server authentication was selected, enter the credentials.
7
Click OK.
To select the custom script
1
After defining the target database information, click Select a script.
2
Select a custom script to run.
3
Click OK.
4
Click Run.
- OR -
Optionally, enter any arguments required for this script.
To enter script arguments
1
After selecting a custom script, click Enter script arguments.
2
Type the required information for each argument.
3
Click OK.
4
Click Run.

PowerShell cmdlets

The Enterprise Reporter Database Content Wizard includes PowerShell cmdlets that can be used to schedule database content management tasks.

See also:

•
Requirements
•
Database Content Wizard cmdlets
•
Loading the Database Content Wizard cmdlet
•
Backing Up An Enterprise Reporter Database
•
Cleaning an Enterprise Reporter Database
•
Merging Two Enterprise Reporter Databases
•
Restoring an Enterprise Reporter Database
•
Transferring an Enterprise Reporter Database

Requirements

•
Windows Management Framework 3.0
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating