> In most cases you can generate the script you need completely automatically from a diff tool. I'd like to know what most cases is here, a diff tool isn't go

> In most cases you can generate the script you need completely automatically from a diff tool. I'd like to know what most cases is here, a diff tool isn't going to know whether adding a column and removing a column is a rename (assuming the right types), or whether they really are different columns. A diff tool isn't going to know what the value needs to be for your new non-NULL, non-DEFAULT column (nor is it going to know that for a NULL column existing data does need a value, but that new data needs a different value, if there is even a singular value that it can use).