Chat now with support
Chat with Support

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

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

Merging Two Enterprise Reporter Databases

This section provides details about the Merge task.

 
* 
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.

Syntax

Start-ERMerge [-SourceSqlHost] <string> [-SourceDatabaseName] <string>
[[-SourceUserID] <string>] [[-SourcePassword] <string>] [-TargetSqlHost] <string>
[-TargetDatabaseName] <string> [[-TargetUserID] <string>] [[-TargetPassword] <string>] [<CommonParameters>]

Parameters

•
[-SourceSqlHost] is the name of the SQL Server that holds the source database to be merged.
•
[-SourceDatabaseName] is the name of the database containing the data that will be moved in the merge.
•
[-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 a to the source database. If not provided, Windows credentials are used.
•
[-TargetSqlHost] is the name of the SQL Server that holds the target database.
•
[-TargetDatabaseName] is the name of the database that will contain the merged data.
•
[-TargetUserID] (optional) is the SQL Server user ID used to connect to the target database. If not provided, Windows credentials are used.
•
[-TargetPassword] (optional) is the SQL Server password to the target database. If not provided, Windows credentials are used.
To merge two databases using Windows authentication
•
Provide values for SourceSqlHost, SourceDatabaseName, TargetSqlHost and TargetDatabaseName.
Start-ERMerge –SourceSqlHost Sample.Sql.Server –SourceDatabaseName SourceDatabase –TargetSqlHost TargetSample.Sql.Server –TargetDatabaseName TargetDatabase
To merge two databases using SQL Server authentication
•
Provide values for SourceSqlHost, SourceDatabaseName, SourceUserID, SourcePassword, TargetSqlHost, TargetDatabaseName, TargetUserID and TargetPassword.
Start-ERMerge –SourceSqlHost Sample.Sql.Server –SourceDatabaseName SourceDatabase –SourceUserID TestUser –SourcePassword fee3td
–TargetSqlHost TargetSample.Sql.Server –TargetDatabaseName TargetDatabase –TargetUserId TargetUser –TargetPassword fhfsk8

Restoring an Enterprise Reporter Database

This section provides details about the Restore task.

Syntax

Start-ERRestore [-TargetSqlHost] <string> [-TargetDatabaseName] <string>
[[-TargetUserID] <string>][[-TargetPassword] <string>] [-FilePath] <string>
[-Password] <string> [<CommonParameters>]

Parameters

•
[-TargetSqlHost] is the name of the SQL Server that holds the target database.
•
[-TargetDatabaseName] is the name of the database that the restore task will populate with restored data.
•
[-TargetUserID] (optional) is the SQL Server user ID used to connect to the target database. If not provided, Windows credentials are used.
•
[-TargetPassword] (optional) The SQL Server password to the target database. If not provided, Windows credentials are used.
•
[-FilePath] is the full path to the backup .erbackup file, including the file name with file extension.
Example: C:\Users\Jane\Desktop\BackupFile.erbackup
•
[-Password] is the password that was be used to encrypt the backup file and is now required to access the file during the restore process.
To restore a database using Windows authentication
•
Provide values for TargetSqlHost, TargetDatabaseName. FilePath, and Password.
Start-ERRestore –TargetSqlHost Sample.Sql.Server –TargetDatabaseName RestoreDB –FilePath C:\Users\Bob\Documents\TestDB –Password 77dhw
To restore a database using SQL Server authentication
•
Provide values for TargetSqlHost, TargetDatabaseName, TargetUserID, and TargetPassword.
Start-ERRestore –TargetSqlHost Sample.Sql.Server –TargetDatabaseName RestoreDB –TargetUserId TestUser –FilePath fee3td –FilePath C:\Users\Bob\Documents\TestDB –Password 77dhw
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating