Rebuild the reporting. Preserve the routine.

01 / The context

The problem behind the project.

A reporting migration involved more than moving report files. Connection behavior, permissions, saved filters, scheduling, and delivery settings had to remain understandable after the environment changed. When the restore-and-upgrade path failed, the reporting estate needed a controlled rebuild.

02 / The contribution

How I approached it.

1. Rebuilt the SSRS environment from a fresh setup and re-imported and tested 105 reports.
2. Reworked connection behavior to remove stored report usernames and passwords, and compared report definitions through their XML representation.
3. Extracted subscription parameters, delivery details, and schedules, preserving repeated elements and parameter order while reconstructing the target settings.
4. Built comparison tooling for the reconstructed configuration and delivery infrastructure with logging to prevent repeated sends. Client acceptance checks also compared selected subscriptions with manually run reports.

03 / The result

What the work made possible.

A reconstructed reporting environment with a repeatable subscription-migration path. The documented 100% figure refers specifically to agreement of reconstructed settings—not a blanket claim that every report, data value, or delivery was independently tested without exception.