endorsedOngoing

SSRS Report Migration & Ransomware Recovery for Eldercare Software

Services Covered:

Custom Software Development • Database Development and Management • Data Migration • Security Operations (SecOps) • Software Maintenance and Support

Industry

Information Technology

Duration

103 months

Budget

10K - 49K

Start Date

1 January 2018

Team Size

1-5 Employees

Engagement Model

Offshore

Project Capability Score (PCS)

80/100

Strong

Project Capability Score (PCS) estimates how capable Prishusoft is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Eldercare Tech Firm

Saint Paul, United States of America

Project Summary

Prishusoft provided ongoing web and SQL development for an eldercare software provider, migrating a large number of reports and data tables and writing migration scripts. During a ransomware/malware incident they worked through the night to preserve and restore the client's software and server configuration, resolving the situation quickly and earning the client's trust.

Key Challenges

Convert a legacy Microsoft Access application to a web-based system
Migrate a large number of reports from the legacy system into SSRS
Handle poorly structured and complex reports and the SQL behind them

Project Deliverables

SSRS configuration and setup
Migration of ~700 reports to SSRS
Scripted data migration for ~500 data tables
Recovery of software and server configuration after a malware attack

Project Solution

Prishusoft configured SQL Server Reporting Services (SSRS) to work with the client's environment and migrated roughly 700 reports from a legacy Microsoft Access system to SSRS. They wrote a script to accelerate a time-consuming data migration across approximately 500 tables and assisted in recovering software and server configuration during a malware/ransomware attack, restoring operations within one day.

Project Outcome

Restored systems and had the client up and running within one day after a malware attack
Migrated approximately 700 reports to SSRS and scripted migration for ~500 data tables
High client satisfaction and trust; technical ratings given: 10/10 for SSRS, 8/10 for Microsoft SQL, 9/10 for scripting

Platforms

Tech Stack

SQL
Microsoft SQL Server

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“When attacked by ransomware, Prishusoft worked throughout the night to preserve the client's software and server configuration. The situation resolved quickly, and the client praises Prishuosoft's commitment and investment. They've proven themselves to be a trustworthy and valuable remote partner.”
Anonymous
Founder
Date: 01/29/2021