迁移报表服务器安装Migrate a report server installation

了解如何将现有 SQL Server Reporting Services (SSRS) 实例迁移到 Power BI 报表服务器实例中。Learn how to migrate your exising SQL Server Reporting Services (SSRS) instance to an instance of Power BI Report Server.

迁移的定义为将应用数据文件移到新的 Power BI 报表服务器实例中。Migration is defined as moving application data files to a new Power BI Report Server instance. 需要迁移安装的常见可能原因如下:The following are common reasons why you might migrate your installation:

  • 要将 SQL Server Reporting Services 迁移到 Power BI 报表服务器You are wanting to move from SQL Server Reporting Services to Power BI Report Server

    备注

    无法从 SQL Server Reporting Services 就地升级到 Power BI 报表服务器。There is not an inplace upgrade from SQL Server Reporting Services to Power BI Report Server. 必须进行迁移。A migration is necessary.

  • 具有大规模部署或更新要求You have a large scale deployment or update requirements
  • 要更改硬件或安装拓扑You are changing the hardware or topology of your installation
  • 遇到阻止升级的问题You encounter an issue that blocks upgrade

从 SSRS(本机模式)迁移到 Power BI 报表服务器Migrating to Power BI Report Server from SSRS (Native mode)

从 SSRS(本机模式)实例迁移到 Power BI 报表服务器的过程分为几步。Migrating from an SSRS (Native mode) instance to Power BI Report Server consists of a few steps.

备注

SQL Server 2008 Reporting Services 及更高版本支持迁移。SQL Server 2008 Reporting Services and later are supported for migration.

  • 备份数据库、应用和配置文件Backup database, application and configuration files
  • 备份加密密钥Back up the encryption key
  • 克隆托管报表的报表服务器数据库Clone your report server database hosting your reports
  • 安装 Power BI 报表服务器。Install Power BI Report Server. 如果使用的硬件相同,可以在 SSRS 实例所在的同一服务器上安装 Power BI 报表服务器。If you are using the same hardware, you can install Power BI Report Server on the same server as the SSRS instance. 若要详细了解如何安装 Power BI 报表服务器,请参阅安装 Power BI 报表服务器For more information on installing Power BI Report Server, see Install Power BI Report Server.

备注

Power BI 报表服务器的实例名称为 PBIRS。The instance name for the Power BI Report Server will be PBIRS.

  • 使用报表服务器配置管理器配置报表服务器,并连接克隆的数据库。Configure the report server using Report Server Configuration Manager and connect to the cloned database.
  • 执行 SSRS(本机模式)实例所需的任何清除操作Perform any cleanup needed for the SSRS (Native mode) instance

从 SSRS(SharePoint 集成模式)迁移到 Power BI 报表服务器Migration to Power BI Report Server from SSRS (SharePoint-integrated mode)

从 SSRS(SharePoint 集成模式)迁移到 Power BI 报表服务器并不像本机模式一样简单。Migrating from an SSRS (SharePoint-integrated mode) to Power BI Report Server is not as straight forward as native mode. 虽然这些步骤可以在一定程度上指导你如何迁移,但 SharePoint 中可能还有其他文件和资产需要进行管理,而这些步骤并未涉及。While these steps will provide some guidance, you may have other files and assets within SharePoint that will need to be managed outside of these steps.

需要将特定的报表服务器内容从 SharePoint 迁移到 Power BI 报表服务器。You will need to migrate the specific report server content from SharePoint to your Power BI Report Server. 这样做的前提是,已在环境中的某个位置安装了 Power BI 报表服务器。This assumes you have already installed Power BI Report Server somehwere in your environment. 若要详细了解如何安装 Power BI 报表服务器,请参阅安装 Power BI 报表服务器For more information on installing Power BI Report Server, see Install Power BI Report Server.

如果要将报表服务器内容从 SharePoint 环境复制到 Power BI 报表服务器中,需要使用 rs.exe 等工具来复制内容。If you want to copy the report server content from your SharePoint environment to Power BI Report Server, you will need to use tools such as rs.exe to copy the content. 下面的示例展示了用于将报表服务器内容从 SharePoint 复制到 Power BI 报表服务器的脚本。Below is a sample of what the script would be to copy report server content from SharePoint to Power BI Report Server.

备注

示例脚本应该会对 SharePoint 2010 及更高版本和 SQL Server 2008 Reporting Services 及更高版本产生不利影响。The sample script should work against SharePoint 2010 and later and SQL Server 2008 Reporting Services and later.

示例脚本Sample script

Sample Script
rs.exe
-i ssrs_migration.rss -e Mgmt2010
-s http://SourceServer/_vti_bin/reportserver
-v st="sites/bi" -v f="Shared Documents“
-u Domain\User1 -p Password
-v ts=http://TargetServer/reportserver
-v tu="Domain\User" -v tp="Password"

从一个 Power BI 报表服务器迁移到另一个Migrateing from one Power BI Report Server to another

从一个 Power BI 报表服务器迁移到另一个的过程与从 SSRS(本机模式)迁移一样。Migrating from one Power BI Reprot Server is the same process as migrating from SSRS (Native-mode).

  • 备份数据库、应用和配置文件Backup database, application and configuration files
  • 备份加密密钥Back up the encryption key
  • 克隆托管报表的报表服务器数据库Clone your report server database hosting your reports
  • 安装 Power BI 报表服务器。Install Power BI Report Server. 无法在要从其迁移的 Power BI 报表服务器所在的同一服务器上安装 Power BI 报表服务器。You cannot install Power BI Report Server on the same server as the one you are migrating from. 若要详细了解如何安装 Power BI 报表服务器,请参阅安装 Power BI 报表服务器For more information on installing Power BI Report Server, see Install Power BI Report Server.

备注

Power BI 报表服务器的实例名称为 PBIRS。The instance name for the Power BI Report Server will be PBIRS.

  • 使用报表服务器配置管理器配置报表服务器,并连接克隆的数据库。Configure the report server using Report Server Configuration Manager and connect to the cloned database.
  • 执行旧版 Power BI 报表服务器安装所需的任何清除操作。Perform any cleanup needed for the old Power BI Report Server installation.

后续步骤Next steps

管理员手册Administrator handbook
快速入门:安装 Power BI 报表服务器Quickstart: Install Power BI Report Server
rs.exe 实用工具脚本和 Web 服务Script with the rs.exe Utility and the Web Service

更多问题?More questions? 尝试咨询 Power BI 社区Try asking the Power BI Community