ALTER TABLE ... MODIFY CONSTRAINT ...

Early Access Program for Schema Compare for Oracle

Moderators: David Atkinson, eddie davis, richardjm, alice.easey, Tom Harris

ALTER TABLE ... MODIFY CONSTRAINT ...

Postby kAlvaro » Mon Jan 18, 2010 12:39 pm

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:

Code: Select all
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
 
Posts: 9
Joined: Mon Jan 18, 2010 11:33 am
Location: Spain

Postby Simon C » Mon Jan 18, 2010 1:52 pm

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
 
Posts: 140
Joined: Tue Feb 26, 2008 4:56 pm
Location: Red Gate Software

Re:

Postby kAlvaro » Mon Jan 18, 2010 4:29 pm

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.)
Álvaro G. Vicario - Burgos, Spain
kAlvaro
 
Posts: 9
Joined: Mon Jan 18, 2010 11:33 am
Location: Spain

Postby alice.easey » Wed Mar 10, 2010 6:07 pm

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.easey
 
Posts: 94
Joined: Wed Feb 27, 2008 12:56 pm
Location: Red Gate

Re:

Postby kAlvaro » Thu Mar 18, 2010 2:03 pm

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.
Álvaro G. Vicario - Burgos, Spain
kAlvaro
 
Posts: 9
Joined: Mon Jan 18, 2010 11:33 am
Location: Spain


Return to Schema Compare for Oracle Beta

Who is online

Users browsing this forum: No registered users and 0 guests