SYSTEM AND METHOD FOR IMPLEMENTING DATABASE REPLICATION CONFIGURTIONS USING REPLICATION MODELING AND TRANSFORMATION

摘要

A reverse engineering database replication data system is disclosed. In one embodiment, the replication data system receives an input of replication configuration data for a plurality of databases and builds memory models based on metadata accessed from the plurality of databases, which are then transformed to a first platform-specific replication model. Then, based on the first platform-specific replication model, a first universal replication model is configured, which is used to create a replication visual model using the rendering canvas. A user may modify the first universal replication model using the replication visual model to create a second universal replication model, which is then transformed to a second platform-specific replication model. Finally, scripts are generated for the second platform-specific replication model, which are then provided to a memory device.

主权项

1. A method for reverse engineering database replication configuration data performed by at least one processor connected to a plurality of databases, the method comprising:
receiving, using the at least one processor, an input of replication configuration data for a plurality of databases; building, using the at least one processor, at least one memory model based on metadata accessed from the plurality of databases; transforming, using the at least one processor and based on the replication configuration data, the at least one memory model to a first platform-specific replication model, the first platform-specific replication model being configured for a first platform; generating, using the at least one processor and based on the first platform-specific replication model, a first universal replication model configured for a plurality of platforms, the first universal replication model including a rendering canvas configured to receive at least one user-identified modification of the first universal replication model; creating, using the at least one processor and based on the first universal replication model, a replication visual model using the rendering canvas, the replication visual model including configurable target and source properties; modifying, using the at least one processor, a property of the first universal replication model using the replication visual model to create a second universal replication model; transforming, using the at least one processor, the second universal replication model to a second platform-specific replication model, the second platform-specific replication model being configured for a second platform; generating, using the at least one processor, at least one script based on the second platform-specific replication model; and providing, using the at least one processor, the at least one script to a memory device.