APPARATUS, SYSTEM, AND METHOD FOR SYNCHRONIZING A REMOTE DATABASE

摘要

An apparatus, system, and method are disclosed for synchronizing a remote database. A monitor module monitors an update from a database application to a primary table of a primary database. The update is communicated through an application server. The application server is configured to manage access to the primary database by the database application. A construction module constructs a SQL command in text format that is equivalent to the update. An update module applies the SQL command to a backup table of a backup database. The backup table is a logical mirror image of the primary table prior to the application of the update to the primary table. In one embodiment, a verification module verifies that the SQL command is successfully applied to the backup table.