Hey Dean,

We've been using SQL Compare for a couple of years now on a similarly large DB schema.  The only issue we've run into with the latest version is with non-nullable columns with a default.  We've found that we have to insert the column instead of adding it at the bottom of the list, then set the option to enforce column order.  This forces a new table to be built and the data transferred to it instead of adding the column to the existing table definition which will fail.  It sounds to me like some of the settings you've used need to be adjusted.  I'd especially check on the "Include dependant database objects" option.

I've checked out Embarcadero's Change Manager product and didn't like it as well as SQL Compare, but haven't heard of DB Ghost.  I'm going to look it up and give it a run.  Thanks for the tip!

Mike