Practice management, billing, and ERP platforms all live on top of a database that someone has to actually administer. Here's what good DBA discipline looks like for legal and financial systems, and how to carry it through a cloud migration without losing data integrity along the way.
Every platform we've covered in this series — Aderant, 3E/Elite, Intapp, Onit, PeopleSoft, NetSuite, and the rest — ultimately comes down to a relational database doing the real work underneath the application layer. Firms spend a lot of time evaluating the application itself and comparatively little time on the database tier that holds the general ledger, the time and billing history, and every client record the firm has. That's backwards. A platform migration or upgrade is only as good as the database administration discipline behind it, and that discipline matters even more once the database moves to the cloud.
For most of the legal and financial platforms firms run — SQL Server-backed practice management systems, Oracle-based ERP, or a cloud-native platform's managed database — the fundamentals don't change, but the stakes do. A corrupted billing database or a botched restore during month-end close is a business continuity event, not just an IT ticket.
Moving the database tier to a managed cloud service — Azure SQL, AWS RDS, or a vendor's own hosted environment — removes a lot of the hardware and patching burden, but it doesn't remove the need for DBA judgment. It relocates where that judgment has to be applied.
Cloud-managed databases are typically billed and throttled by compute tier (DTUs, vCores, or IOPS), which means a query that ran fine on dedicated on-prem hardware can suddenly hit a resource ceiling in the cloud. We've seen this bite firms hardest on month-end and year-end batch jobs — the kind of heavy reporting runs that used to just take longer on a quiet server and now get throttled outright. Right-sizing the compute tier, and re-tuning the handful of expensive queries that drive it, is a real pre-migration task, not an afterthought.
Most cloud database services handle automated backups by default, which is genuinely an improvement over firms that were quietly skipping verification on-prem. But "the cloud provider handles backups" is not the same as "our recovery point and recovery time objectives are met." Firms still need to define their own RPO/RTO targets and confirm the managed service's defaults actually satisfy them — point-in-time restore windows, geo-redundancy, and who can trigger a restore all need to be explicitly checked, not assumed.
Row counts matching between source and target is the bare minimum, not proof of a clean migration. For financial and billing systems specifically, we validate referential integrity (every time entry still ties to a valid matter and client), balance reconciliation (trial balance and AR aging tie out pre- and post-migration), and character encoding (client names and addresses with accented characters or special characters are a surprisingly common silent casualty of a database migration).
An application server and database that used to sit on the same LAN segment now talk over a network connection with real latency. Chatty applications — ones that make many small round-trip queries rather than fewer larger ones — feel this acutely. It's worth profiling application-to-database call patterns before migration, because "the database is slow" after a cloud migration is very often actually "the network round-trip is now non-zero, and the application was never designed to care."
The database tier is the least glamorous part of any legal or financial systems project, and it's exactly where migrations quietly go wrong — not because the cloud platform is unreliable, but because the DBA fundamentals that kept the on-prem system healthy get skipped in the rush to cut over. Firms that treat database administration as its own workstream, with its own validation and sign-off, consistently have smoother migrations and fewer surprises in the months after go-live.
Planning a database migration or upgrade for your practice management, billing, or ERP system? We handle the DBA and data integrity work alongside the application migration — across SQL Server, Oracle, and cloud-managed platforms.
Book a Free Consultation →