Software SSRS Migrate SSRS Migrate Features

© Defacto 2018

Contact us

Simplify Business Intelligence

Home

2ndRock

Home Software Download Purchase Software Support

Feature List

SSRS Migrate

Migration Scripts




SSRS Versions support



Every SSRS version 2000-2017 + Power BI

Yes

No

SSRS 2008r2 and later

Yes

Yes

Mode Migration



Native to native

Yes

Yes

Native to SharePoint

Yes

Yes

SharePoint to SharePoint

Yes

Yes

Migration Options



Set different  root folder locations on source and destination

eg migrate all items in folder /UAT to / on the destination server ##1

Yes

No

Brick level migration

Yes

No

Pre Validation



Validate upload is limit is bigger than largest item to upload

Yes

No

Create backup of configuration files

Yes

No

Update configuration files

Yes

No

Security



Compare role differences source to destination server

Yes

No

Compare system role differences source to destination server

Yes

No

Create role

Yes

Yes

Create system role

Yes

Yes

Update role

Yes

No

Update system role

Yes

No

Identify security issues ##2



Shared Schedules



Identify issues - native > integrated migration Month day of week schedule

Yes

No

Create shared schedules

Yes

Yes

Optional: Map source schedule to existing destination schedule

Yes

No

Brick level Migration (Create)



eg migrate only reports

Yes

No

Brick level Update



eg migrate only reports existing on destination server

Yes

No

Brick level Deployment- Migrate and update



eg deploy development> production

Yes

No

Shared Data Sources



Migrate shared data sources without account details

Yes

Yes

Migrate shared data sources with verified account details

Yes

No

Migrate new data sources (optional)

Yes

No

Update existing data sources (optional)

Yes

No

Transform shared data sources eg SQL > Azure

Yes

No

Shared Datasets



Migrate shared datasets

Yes

Yes

Identify + fix orphaned datasets

Yes

No

Migrate new datasets (optional)

Yes

No

Update existing datasets (optional)

Yes

No

Folder



Migrate new items

Yes

Yes

Migrate new folders (optional)

Yes

No

Update existing folder (optional)

Yes

No

Reports



Migrate new reports

Yes

Yes

Migrate new reports (optional)

Yes

No

Update existing reports (optional)

Yes

No

Upgrade RDL version

Yes

No

Update RDL image location URL

Yes

No

Update RDL drill through, drill down reports URL

Yes

No

Update report parameters

Yes

Yes

Linked Reports



Migrate new items

Yes

Yes

Migrate new linked reports (optional)

Yes

No

Migrate existing linked reports (optional)

Yes

No

Identify + fix orphaned linked reports

Yes

No

Update linked report parameters

Yes

Yes

Subscriptions



Migrate report and/or linked report subscriptions

Yes

No

View all subscriptions

Yes

No

View subscription errors and fix

Yes

No

Identify and fix subscription schedule issues-  Month day of week  ##3

Yes

No

Migrate subscriptions

Yes

Yes

Migrate subscription account details

Yes

No

Validate user accounts for file shares

Yes

No

Validate file shares exist

Yes

No

Integrated to native migration: convert SharePoint document library to file share

Yes

No

Change subscription owner for builtin\administrators

Yes

Yes

Change subscription owner where migration user not member of builtin\adminstrators

Yes

No

Set data driven subscription custom data source account details

Yes

No

User Reports folders



Migrate all users reports items

Yes

No

Migration all items in users folders

Yes

No

History settings



History

No

No

Migrate history settings (details not migrated)

Yes

Yes

Cache refresh plans



Create cache refresh plans

Yes

Yes

KPI Report



Migrate KPI report

Yes

?

Mobile Report



Migrate mobile report

Yes

?

relink dataset

Yes

?

Logging



Full migration logging

Yes

No

Supports long file names

Yes

No

Save source/destination migration items to file

Yes

No

Save source/destination migration items to zip file

Yes

No

Key

##1 Root folders location.

##2 security issues no accounts on non inherited item. Occurs when accounts are deleted from the AD leaving no users or groups in the items permissions

##3 Month day of week schedule is not supported in SSRS Integrated (SharePoint)

How  Does SSRS Migrate Compare to Migration Scripts?


If you use one of the migration scripts you will not have a working migration. There is a lot of manual post work required. This is where SSRS Migrate differs.

If you use an SSRS migration script on the internet this will be the state of your SSRS destination server

migrating native to native with different destination folder or

migrating integrated to integrated then you need to:

update each RDL report where

SSRS Migrate Feature List