Synchronization scripts

Aaron S

Is there any way for me to configure the method the synchronization script uses to add columns to a table? For example, for some (or all) tables I might prefer that when adding a column to a table a new table be created and the data copied over rather than using the ALTER TABLE ADD COLUMN command. It is my understanding that there is some potential performance advantage to do this as it avoids page splits.

Thanks,
Aaron

Brian Donahue

Hi Aaron,

The only option I can think of is that one, 'force column order to be identical'. That would enforce a table rebuild. Only if the column ordinal of the new column is different, though...