Dbvisit Replicate can replicate on different levels. It can replicate:
- Whole database (except sys and system objects).
- Whole schemas.
- Individual tables.
- PL/SQL (1)
Dbvisit Replicate replicates both:
- DML (data changes)
- DDL Not all DDL is supported. For example create tablespace is not supported. DDL is only supported for if the target is an Oracle database.
Dbvisit Replicate does NOT replicate:
- Triggers
- Constraints
- Sequences
- Database structure
- ALTER DATABASE commands
- ALTER SYSTEM commands
Note 1 PL/SQL replication works as follows:
- Dbvisit Replicate does not support creating the initial copy of the PL/SQL code.
- Dbvisit Replicate replicates all create/alter/drop procedure/function/package/package body commands. Dbvisit Replicate does not replicate the actual code, Dbvisit Replicate replicates all DDLs for it.
- Dbvisit Replicate currently does not replicate triggers, java, types, objects, synonyms, indextypes, mining models, editions, assemblies, flashback archives.
1
PL/SQL replication works as follows:
- Dbvisit Replicate does not support creating the initial copy of the PL/SQL code.
- Dbvisit Replicate replicates all create/alter/drop procedure/function/package/package body commands. Dbvisit Replicate does not replicate the actual code, Dbvisit Replicate replicates all DDLs for it.
- Dbvisit Replicate currently does not replicate triggers, java, types, objects, synonyms, indextypes, mining models, editions, assemblies, flashback archives.