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

Database Content Wizard cmdlets

The cmdlets included with the Database Content Wizard are as follows:

•
Start-ERBackup
•
Start-ERClean
•
Start-ERMerge
•
Start-ERRestore
•
Start-ERTransfer

Loading the Database Content Wizard cmdlet

To load the Database Content Wizard cmdlet (without feedback):
•
Import-Module “File path to the DatabaseContentWizardCmdlets.dll”
To load the Database Content Wizard cmdlet (with feedback):
•
Import-Module “File path to the DatabaseContentWizardCmdlets.dll” –verbose
To redirect PowerShell error logging
•
Append the command with 2>{full path}
Example: Start-ERBackup 2>C:/error.txt

Backing Up An Enterprise Reporter Database

This section provides details about the Backup task.

Syntax

Start-ERBackup [-SourceSqlHost] <string> [-SourceDatabaseName] <string>
[[-SourceUserID] <string>][[-SourcePassword] <string>] [-FilePath] <string>
[-Password] <string> [<CommonParameters>]

Parameters

•
[-SourceSqlHost] is the name of the SQL Server that holds the source database.
•
[-SourceDatabaseName] is the name of the database containing the data to be backed up.
•
[-SourceUserID] (optional) is the SQL Server user ID used to connect to the source database. If not provided, Windows credentials are used.
•
[-SourcePassword] (optional) is the SQL Server password to the source database. If not provided, Windows credentials are used.
•
[-FilePath] is the full path to the backup file, including the file name.
Example: C:\Users\Jane\Desktop\BackupFile.erbackup
•
[-Password] is the password that will be used to encrypt the backup file and will be required to access the file during any restore process. This password is encrypted and is unrecoverable.
To back up a database using Windows authentication
•
Provide values for SourceSqlHost, SourceDatabaseName, FilePath, and Password.
Start-ERBackup –SourceSqlHost Sample.Sql.Server –SourceDatabaseName TestDB –FilePath C:\Users\Bob\Documents\TestDB –Password 77dhw
To back up a database using SQL Server authentication
•
Provide values for SourceSqlHost, SourceDatabaseName, SourceUserID, SourcePassword, FilePath, and Password.
Start-ERBackup –SourceSqlHost Sample.Sql.Server –SourceDatabaseName TestDB –SourceUserID TestUser –SourcePassword fee3td –FilePath C:\Users\Bob\Documents\TestDB –Password 77dhw

Cleaning an Enterprise Reporter Database

This section provides details about the Clean task.

Syntax

Start-ERClean [-XmlFilePath] <string> [<CommonParameters>]

Parameters

•
[-XmlFilePath] is the full path of the XML file used for running the clean task.
To clean a database using Windows authentication
•
Provide values for SqlHost and DatabaseName for the SourceSqlParameters element within the XML.
Start-ERClean -XmlFilePath C:\Users\Bob\Documents\CleanTask.xml
To clean a database using SQL Server authentication
•
Provide values for SqlHost, DatabaseName, UserName and Password for the SourceSqlParameters element within the XML.
Start-ERClean -XmlFilePath C:\Users\Bob\Documents\CleanTask.xml
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating