How can we help you today? How can we help you today?

Synchronization scripts

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
Aaron S
0

Comments

1 comment

Sort by
  • 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...
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.