| 摘要 |
The replication of large amounts of data from a database source to a database target is often prone to failure when the amount of data exceeds the transaction capacity of the database. In other words, if the amount of data transfer during initial start-up fills the transaction log before the database changes are committed, then the transaction does not complete and the changes are rolled back. For a transaction to be completed and database changes to be made permanent, the transaction must be completed in its entirety. A method for initializing data propagation execution for a large data source according to an embodiment of the invention uses standard DBMS copy, rename and log clearing/cleaning utility applications to successfully complete an initial load process so that all necessary initialization fields are primed. The method steps create temporary database table names and structures and execute an initialization/cold start using a single data record to set a synchronization point marker. Upon validation of the single record initialization, the replication of the large data table proceeds in a continue/warm mode from the set synchronization point marker. Executable instruction steps and computer readable media incorporating the executable instruction steps are disclosed.
|
