Case Study: Metro Housing Authority achieves improved performance and automated reporting by splitting its central database with Astera Software

Metro Housing Authority Uses Astera to Split the Central Data System into Two Databases

Metro Housing Authority, a public-sector organization, ran a central SQL Server database accessed by about 300 concurrent users for both applications and reporting. Heavy mixed use caused performance problems, so IT Manager Donald Butler decided to split the system into two databases—one for applications and one for reporting—with the reporting database periodically mirroring a subset of application tables.

Butler tried SSIS but found it too complex and adopted Astera, a scalable data-integration platform with parallel processing that handled syncing, mapping, transformation, parsing, and extraction. Astera made mirroring, inserts, and updates simple and automatable; it quickly became a daily utility for other data-management tasks. The solution was cost-effective, user-friendly, and restored system performance while enabling ongoing automation.