What are the challenges you face when working across database platforms? Take the survey

Synchronization scripts

Aaron SAaron S Posts: 11
edited May 23, 2006 10:15PM in SQL Compare Previous Versions
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.



  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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...
This discussion has been closed.