How to migrate data from development to production Report Server

How to migrate data between the servers

This article explains the steps required to migrate data between the servers:

1. Before migrating the Report Server from ‘Old server’, take a backup of the database and its resources, and follow the below help link to take backup.

https://help.syncfusion.com/report-platform/report-server/utilities/backup

2. Install the Report Server into the new server.

3. Copy the ‘App_Data’ folder from the ‘Old Server’ and create an ‘App_Data’ folder in the ‘New Server’ in the following location.

C:\Syncfusion\Report Server\ReportServer.Web

4. To update the database details to the newly copied database, the connection string will be in encrypted format in the following file.

C:\Syncfusion\Report Server\ReportServer.Web\App_Data\Configuration\Config.xml

To decrypt the connection string, follow the given steps:

1. Download the decrypt utility from the following link and extract it.

        https://www.syncfusion.com/downloads/support/directtrac/general/ze/DecryptUtility-11329488351222148906952689970

2. Open “Config.xml” from the following location in the Syncfusion Report Server installed machine. Copy the connection string as follows.

C:\Syncfusion\Report Server\ReportServer.Web\App_Data\Configuration 

3. Run “DecryptUtility.exe” and provide the connection string. The decrypted connection string will be obtained.

4. Then, create a new connection string for the database as same as the decrypted connection string format.

5. Encrypt the connection string and update the value in “<connectionString>” node in the “config.xml”.

To encrypt the new connection string, follow the given steps:

1. Download a zip file from the following location.

https://www.syncfusion.com/downloads/support/directtrac/general/ze/EncryptUtility20094855781379628879982849125

2. Extract the zip file and run the following 'DecryptUtility.exe' file from the extracted file.

3. Provide the connection string as follows. Now, you can get the encrypted connection string.

4. Then, update the encrypted connection string in the node <ConnectionString> </ConnectionString> of the config.xml file, and you can find the file in the following location.

C:\Syncfusion\Report Server\ReportServer.Web\App_Data\Configuration\Config.xml 

5. Browse the hosted Report Server site as follows.

6. Click the site settings in the Report Server and update the site URL as per the hosted URL. For more details, refer to the following link.

https://help.syncfusion.com/report-platform/report-server/site-settings/custom-rebranding#site-url