What are the challenges you face when working across database platforms? Take the survey

Deploying Static Data from Source Control

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?

Best Answer

  • Options
    Alex BAlex B Posts: 1,146 Diamond 4
    Answer ✓
    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
    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,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.