How the sequencing of object creation is take care ?

gahujagahuja Posts: 33
edited November 26, 2014 3:35AM in Schema Compare for Oracle
Hi Richard

question is regarding the sequence of object creation while deploying the diff script

e.g if during deployment script view is getting created based on any table or index is created on basis of any table so ofcourse that table should be created first

I'm sure Red gate oracle schema comparison must be taking care of that internally but I would like to know what is the sequence of order redgate is following to handle
internally object dependencies

Thanks
Gagan

Comments

  • Eddie DEddie D Posts: 1,800 Rose Gold 5
    Hi Gagan

    Thank you for your forum post.

    During the comparison phase, Schema Compare for Oracle analysis the dependencies between objects. If you enable the verbose logging and check the log file generate you will see the queries that Schema Compare for Oracle runs to obtain the dependency information.

    When the deployment process is run or you create a deployment script to run later, the objects are created in dependency order. Therefore using a simple example of a view dependent upon two views and comparing a live schema to a new empty schema, the two tables are created first followed by the view.

    I hope the above answers your question.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.