When synchronizing database schemas, is there a way to control the order of the "ALTER TABLE/ADD COLUMN" statements in the generated script? I want the ordinal position of the columns in the target database to be the same as the source.
There is an advanced option on one of the wizard screens (left hand side) where you can choose to have ordinal position checked in which case it will be catered for.
I tried that and it has no effect on the order of the columns in the script. If you're doing a verification of the two schemas, it will or will not check the ordinal position depending on if the option is checked or not.
synchronizing database schemas
Posted - 12/14/2005 : 13:11:38
