| Author |
Message |
kAlvaro
Joined: 18 Jan 2010
Posts: 9
Location: Spain
|
 Posted: Mon Jan 18, 2010 12:39 pm Post subject: 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:
| Code: |
| 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? |
|
| Back to top |
|
 |
Simon C
Joined: 26 Feb 2008
Posts: 140
Location: Red Gate Software
|
| Posted: Mon Jan 18, 2010 1:52 pm Post subject: |
|
|
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 |
|
| Back to top |
|
|
kAlvaro
Joined: 18 Jan 2010
Posts: 9
Location: Spain
|
| Posted: Mon Jan 18, 2010 4:29 pm Post subject: Re: |
|
|
| 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 |
|
| Back to top |
|
|
alice.easey
Joined: 27 Feb 2008
Posts: 93
Location: Red Gate
|
| Posted: Wed Mar 10, 2010 6:07 pm Post subject: |
|
|
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. |
|
| Back to top |
|
|
kAlvaro
Joined: 18 Jan 2010
Posts: 9
Location: Spain
|
| Posted: Thu Mar 18, 2010 2:03 pm Post subject: Re: |
|
|
| 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 |
|
| Back to top |
|
|
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
