Adding New column for a table which is part of replication
Problem Description
The replication is implemented from schema 1 to schema 2.
A column needs to be added to a table on the source. Since DDL will not be replicated, the client will manually add the same column to the table on the destination environment.
Is there a simple way of telling Dbvisit Replicate to start replicating the new column? OR Would this require unpreparing the table and then preparing the table again now with the new structure?
Solution
Dbvisit Replicate will start replicating the new column without any manual intervention i.e whenever a new column is added to a table it will start replicating it as soon as there is a DML operation to that column. The key will be to add the column to the target database first and then to the source database.
ALTER TABLE EMPLOYEE ADD (SALARY NUMBER(10));Example:
On Source: OE.EMPLOYEES
To Target: HR.EMPLOYEES_N
MINE IS running. Currently at plog 3347 and SCN 89825392 (02/23/2016 14:52:04).
APPLY IS running. Currently at plog 3347 and SCN 89825364 (02/23/2016 14:51:58).
Progress of replication DBTEST:MINE->APPLY: total/this execution
--------------------------------------------------------------------------------------------------------------------------------------------
OE.EMPLOYEE/HR.EMPLOYEES_N: 100% Mine:200/200 Unrecov:0/0 Applied:200/200 Conflicts:0/0 Last:23/02/2016 14:11:31/OK
Note: New column "SALARY" added to EMPLOYEE table was replicated successfully.