Migrate Data from Local Server to Azure app for Report Server and User Management Server.

Migrate Data from Local Server to Azure app for Report Server and User Management Server.

To migrate data from local server to Azure, need to deploy Azure app service using ARM template by following the help link.

https://reports.syncfusion.com/documentation/report-server/installation-and-deployment/azure-deployment/app-service/arm-template-with-new-ums/

Migration of data from local server to Azure app will support for only MSSQL, PostgreSQL database in both Report Server and User Management Server.

Migration of data from local server to Azure app:

1. Follow the given steps to migrate data from local server to Azure app in Report Server.

1. Copy the ‘App_Data’ folder from below location and save in any location.

              C:\Syncfusion\Report Server\ReportServer.Web

2. Log in to the Azure portal: https://portal.azure.com/
3. Select the Syncfusion Report Server App Service.
4. Stop the Report Server Azure App Service and then, click the Get publish profile.

5. Save the <App service name>.PublishSettings file and open it. The file contains two <publishProfile> sections for Web Deploy and FTP.
6. From the FTP <publishProfile> section, copy the following values:

• publishUrl
• username
• userPWD

7. Download and install the FileZilla client application
8. After installing the application, set the values obtained from the PublishSettings file accordingly,

                Host: Give the publishUrl value

                Username: Give the userName value

                Password: Give the userPWD value

9. After entering these values as shown in the following, click Quickconnect.

10.  Now, navigate to the copied “App_Data” file location on the left side and hosted location of the Report Server’/site/wwwroot/App_Data’ on the right side as follows.

          Then move the files to the Azure website by dragging them from the left side to the right side.

2. Follow the given steps to migrate data from local server to Azure app in User Management Server.

1. Copy the ‘App_Data’ folder from below location and save in any location.

              C:\Syncfusion\UMS\UMS.Web

2. Log in to the Azure portal: https://portal.azure.com/
3. Select the Syncfusion User Management Server App Service.
4. Stop the User Management Server Azure App Service and then, click the Get publish profile.

5. Save the <App service name>.PublishSettings file and open it. The file contains two <publishProfile> sections for Web Deploy and FTP.
6. From the FTP <publishProfile> section, copy the following values:

• publishUrl
• username
• userPWD

7. Download and install the FileZilla client application
8. After installing the application, set the values obtained from the PublishSettings file accordingly,

                Host: Give the publishUrl value

                Username: Give the userName value

                Password: Give the userPWD value

9. After entering these values as shown in the following, click Quickconnect.

10.  Now, navigate to the copied “App_Data” file location on the left side and hosted location of the User Management Server’/site/wwwroot/App_Data’ on the right side as follows.

          Then move the files to the Azure website by dragging them from the left side to the right side.

Configure Report Server URL in User Management Server

1. Start the User Management Server Azure App Service and then click on the browse.
2. Update the new UMS URL in UMS – Go to the settings on User Management Server and update the “Site URL” by following the below link.

https://help.syncfusion.com/user-management-server/site-settings/custom-rebranding

3. Update the new Report Server URL in UMS - Update the Report Server application URL in User Management Server by following the below link

https://reports.syncfusion.com/documentation/report-server/user-management-server/manage-applications/#edit-application

Configure User Management Server URL in Report Server

1. Update the new UMS URL in Report Server – Change the UMS Url in Config.xml from the copied “App_Data” location under “Configuration” folder and then save it. Refer the below help link,

https://reports.syncfusion.com/documentation/report-server/faq/change-ums-configurations-in-report-server/

2. Now, navigate to the copied “App_Data\Configuration” file location on the left side and hosted location of the Report Server ‘/site/wwwroot/App_Data/Configuration’ on the right side as follows.

Then move the files to the Azure website by dragging them from the left side to the right side.

3. Start the Syncfusion Report Server Azure App Service and then click on the browse.
4. Update the new Report Server URL in Report Server - Go to the settings on Report Server and update the “Site URL” by following the below link.

https://reports.syncfusion.com/documentation/report-server/custom-rebranding/

By following all the above steps, Report Server Azure instance will be deployed, and the data will be migrated from local to the Azure instance.