Patent ID: 7644112

Claim:
An apparatus to initialize a synchronized remote database, the apparatus comprising: a rename module of a remote data processing system, the rename module configured to rename a first backup table of a backup database of the remote data processing system, the first backup table being renamed from a first name associated with a table name of a primary table of a primary database of a primary data processing system to a second name, the remote and data processing systems being communicable with each other across a network; a creation module of the remote data processing system, the creation module configured to create a second backup table of the backup database from a schema for the primary table of the primary database after the first backup table is renamed, the second backup table being assigned a name corresponding with the first name; a read module of the primary data processing system, the read module configured to read each row from the primary table with an application server configured to manage access to the primary database by a database application; a construction module of the primary data processing system, the construction module configured to construct a Structured Query Language (SQL) command for each row of the primary table, wherein each SQL command is configured to insert data of a primary table row in the second backup table; an application module of the remote data processing system, the application module configured to apply each SQL command to the second backup table to mirror the primary table at the second backup table; and an error mitigation module configured to mitigate an unsuccessful application of at least one SQL command; wherein the rename module is configured to delete the first backup table if each SQL command is successfully applied to the second backup table.