Force table rebuild

aviatoredbaviatoredb Posts: 2
edited September 23, 2009 5:29AM in SQL Compare Previous Versions
Is there an option to force tables to be rebuild instead of altered?
I have a few tables that have changed slightly and they are being synched with alters but the data needs to be manipulated to truly synch them.

Comments

  • Hi there,

    There is an option in SQL Compare to force column order, thus if you were altering the column order of a table then this forces a table rebuild with the data being preserved in a temporary table whilst the drop and create is being done, unless of course any columns are being dropped.

    Would this suit your needs?

    Pete
    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
Sign In or Register to comment.