Deploying Static Data from Source Control
mbruegel
Posts: 43 Bronze 2
I understand that SourceControl can capture static data (e.g. for a look-up table) and how the capture mechanisms work.
However, how do I deploy the static data I've captured to a target table. Does that go along w/ the table information in Schema Compare, or must I run a Data Compare process to populate or sync my captured static data?
However, how do I deploy the static data I've captured to a target table. Does that go along w/ the table information in Schema Compare, or must I run a Data Compare process to populate or sync my captured static data?
Tagged:
Best Answer
-
Alex B
Posts: 1,158 Diamond 4
Hi @mbruegel,
You will need to use Data Compare for Oracle (5.0.0 or later) to deploy the static data. There was also added the/comparison:includeSourceTables
command line switch (see this page) which allows a static data deployment script to be generated using the source schema structure for both the source and target databases. This is important as the target may not yet have the right schema structure for the comparison to run successfully, as it has yet to be deployed to.
I hope that helps!
Kind regards,
Alex
