移轉報表伺服器安裝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 報表伺服器的執行個體名稱會是 PBIRSThe 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 報表伺服器。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 報表伺服器的執行個體名稱會是 PBIRSThe 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