How can we help you today? How can we help you today?

ALTER TABLE ... MODIFY CONSTRAINT ...

I'm evaluating Schema Compare for Oracle to create migration scripts in order to upgrade an application. The code looks good at first sight (all actual changes seem to be reflected) but most of the generated SQL consists on lines like this:
ALTER TABLE "MY_DB"."MY_TABLE" MODIFY CONSTRAINT MY_TABLE_FK;

There're seem to be one for each foreign key, even if none of the involved tables have changed. What's the exact purpose of these MODIFY clauses?
kAlvaro
0

Comments

4 comments

Sort by
  • Simon C
    Constraint modifications are one of the things we havent really tested yet; it's currently being worked on at the moment :)

    As you probably guessed, this is still an early version of the product, and a lot of the functionality isn't tested nearly as well as it would be if it was a final release.

    Out of interest, what constraint properties are different between your databases (if any)?

    thanks,
    SimonC
    Simon C
    0
  • kAlvaro
    Simon C wrote:
    Out of interest, what constraint properties are different between your databases (if any)?

    I've added a couple of tables so two of the existing tables have new foreign keys. There aren't any other changes related to constraints.

    (All the source code is stored in versioned text files so I can compare with any file differencing tool.)
    kAlvaro
    0
  • Alice E
    We've just released our latest early access build.

    We've made considerable improvements to the way we're handling constraints and would really appreciate it if you could try out the latest build and let us know what you think.

    You can download the new build here.

    Thanks,

    Alice.
    Alice E
    0
  • kAlvaro
    alice.easey wrote:
    We've just released our latest early access build.

    We've made considerable improvements to the way we're handling constraints and would really appreciate it if you could try out the latest build and let us know what you think.

    I need to do more testing (I wish I had the time now...) but a preliminary test shows the new release is working way better. The top panel only displays as modified the objects that were actually modified.

    The bottom panel still highlights some differences that are not real because it includes the database name in CREATE TABLE statements but it's a minor issue.
    kAlvaro
    0

Add comment

Please sign in to leave a comment.