### Copy report subscriptions

The SBS Upgrade Package includes a tool that copies the old system report subscriptions. However, since report subscriptions in IONESPMPME are handled differently depending on which SQL Server edition is used, the tool does not work for certain SQL server edition upgrade scenarios.

SQL Server Edition | Scheduling Tool | Configuration UI | Schedule Details
--- | --- | --- | ---
SQL Standard | SQL Agent | Report Management UI in Web Applications | Stored in msdb database (part of SQL Server)
SQL Express | ION Task Scheduler | Report Management UI in Web Applications | Stored in ION_Network database

Use the following information to determine which upgrade process to use:

IONE 6.0.1 SPM 7.0.1 PME 7.2.2 PME 8.2 | PME 8.2 | Upgrade Process
--- | --- | ---
SQL Standard | SQL Standard | Use SBS Upgrade Package tool (see instructions below)
SQL Express | SQL Standard | Use SBS Upgrade Package tool (see instructions below)
SQL Standard | SQL Express | Subscriptions must be recreated in PME (skip this topic)
SQL Express | SQL Express | Subscriptions are automatically transferred with the ION_Network database migration (skip this topic)

Distributed System Note: Complete these tasks on the Application Server.

To copy the report subscriptions:

1. In the `...\SBS Upgrade Package\Report_Subscriptions` folder, locate `ExportSubscriptions.exe` and `IONSubscriptionsHelper.dll`.
2. Copy the 2 files to the `...\ION Enterprise\system\bin``...\Power Monitoring Expert\system\bin` folder on the old ION EnterpriseStruxureWare Power MonitoringPME system.
3. As the Administrator, run `ExportSubscriptions.exe`.

   The tool opens a command prompt and indicates when the task is complete.

   The output of the tool is a file called `...\ION Enterprise\system\bin``...\Power Monitoring Expert\system\bin``\IONSubscriptionData.xml`.

4. Press Enter to close the command prompt window.
5. Copy `IONSubscriptionData.xml` to the `...\SBS Upgrade Package\Report_Subscriptions\` folder.