Manual Migration of SSRS Reports

Manual migration moves reports from SSRS to Bold Reports® one at a time, including their data sources and datasets. Use this approach for a small number of reports, proof-of-concept validation, or when you want to verify each report individually.

What are data sources and datasets in SSRS?

Every SSRS report depends on two components:

  • Data source: a connection to a database, defined by a connection string.
  • Dataset: a query or table definition that returns report data, built on top of a data source.

Both can exist in two forms:

  • Embedded: the connection string (data source) and query (dataset) are stored inside the report file (RDL). Because everything travels with the report, migration needs no extra steps beyond uploading the report.
  • Shared: defined once and referenced by ID across multiple reports. Recreate both the shared data source and the shared dataset in Bold Reports® before the reports that depend on them.

Tip: Keep the same names for datasets and data sources in Bold Reports® as in SSRS, so reports bind automatically during migration. Matching names are not strictly required: if a name doesn't match, you can still select the correct data source and dataset in the Upload Reports dialog. Matching names save you that extra step, especially at volume.

How do I migrate reports with embedded data sources and datasets?

Upload the report file directly. Because the connection string and query are stored inside the report file, no separate data source or dataset setup is required, and the report renders after upload.

Upload reports or add a report in Bold Reports® On-Premise

How do I migrate reports with shared data sources and datasets?

Recreate shared data sources and datasets in Bold Reports® before the reports that reference them. Follow these four steps in order.

Step 1: Gather what you need

  1. Shared data sources cannot be downloaded, so collect their connection details from your database or SSRS administrator first: server name, database name, authentication type, username, and password.
  2. Download the shared datasets from SSRS. They save locally as files that you can upload directly into Bold Reports®.

Important: Migrate the data source before the dataset. A shared dataset is bound to a data source, so the data source must already exist in Bold Reports® before you create the matching dataset.

Step 2: Create the shared data source in Bold Reports®

  1. In Bold Reports®, create a new data source and choose your database type.
  2. Add its connection credentials (the fields shown depend on the database type you chose), then click Save.

How to create a shared data source in Bold Reports® Enterprise

Step 3: Create the shared dataset in Bold Reports®

  1. Download the corresponding shared dataset from SSRS. Then, in Bold Reports®, click Existing Data Source and select the data source you just created.
  2. Enter the dataset name (matching the original SSRS dataset name is recommended) and complete the binding.
  3. Save and exit. The dataset and data source pair is now available in Bold Reports®.

How to create a shared dataset in Bold Reports® Enterprise

Step 4: Migrate the original SSRS report

  1. Click Upload Report and browse to the report file (.rdl) you exported from SSRS.
  2. Attach the migrated data source and dataset to the uploaded report. If the names match the names used in SSRS, this happens automatically. Otherwise, select them manually in the Upload Reports dialog.
  3. Save the report and open it to confirm that it renders and displays data.

Upload reports or add a report in Bold Reports® On-Premise

In what order should I migrate SSRS items?

Always migrate in this order to avoid upload failures:

Shared Data Sources → Shared Datasets → Reports

Next: Once you've migrated and validated a sample of reports manually, continue to Post-Migration Validation. If you have a larger batch remaining, see Automated and Bulk Migration.

Frequently asked questions

When should I use manual migration?

Use manual migration for a small number of reports, proof-of-concept validation, or when you want to verify each report individually.

Can I download shared data sources from SSRS?

No. Shared data sources cannot be downloaded. Collect their connection details from your database or SSRS administrator and recreate them in Bold Reports®.

Do dataset and data source names have to match SSRS?

No, but it is recommended. Matching names bind reports automatically. If a name doesn't match, select the data source and dataset manually in the Upload Reports dialog.

See also