Get Started

One of the biggest concerns for database administrators (DBAs) is the scalability of the databases that they manage.  This is especially true in the case of Anthology Student, an enterprise resource planning (ERP) system servicing the needs of multiple campuses and thousands of students. 

Anthology Student – a single-database system – stores data for multiple campuses in a single Online Transaction Processing (OLTP) database. The single database solution requires the server on which it resides to scale up whenever the number of concurrent users and connections increases.

Transactional replications allow a DBA to scale up the solution by introducing one or more read-only reporting databases. Reporting databases are kept up-to-date using transactional replication. Anthology Student is configured to use reporting databases for running Reports.

IMPORTANT: The replication procedures described in this document are applicable only for self-hosted customers. The procedures are not relevant for Anthology Cloud customers.

Prerequisites and Resource Requirements

  1. This document applies to setting up replication for Anthology Student 18.2 or later, packaged with Financial Aid Automation (FAA) 6.0 or later and Regulatory 10.0 or later.

  2. The Anthology Student database must be running on Microsoft SQL Server 2014 or later. For more detailed information regarding the platforms supported, refer to the Technical Specification Guide and/or the Platform Compatibility tables.

  3. Adequate hardware and software resources must be available to host the reporting database.