Can I apply a Table-To-Table Synchronization rule to synchronize the data between tables in different schemas?
Yes, as long as the schema is in the same database and the primary schema has the access rights to update the child table. If the target schema is not in the same database it is still possible to do this – just trick the Data Masker by making up a “pseudo” table using a synonym and a database link.
Related Questions
- SQL Examiner detects that two tables are different after the database comparison and offers me to synchronize them though I changed only the order of columns. How can I avoid it?
- Is it possible now to export data from Oracle tables and queries selected from different databases to RTF files?
- Can I apply a rule to synchronize the data between tables in different databases?