Overview
We have various versions of databases in house:
* production
* copy of production for development
* development database for mutating
We’d like to get data from a table in one of these databases into the same table of another database. For example, we may want to get a fresh does of production data into the development. This paper talks about cloning records using DBIC.
Examples
Clone server_pri_failover
We do this from prod to dev. We key off of the server_id.
Inputs
source_db, source_table, source_server_id
target_db, target_table, target_server_id
Assumptions
server_id is the primary key or at least unique.
Simplification
Assume source and target server_id (PK) are the same.
Showing changes from previous revision. Removed | Added
