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

Force table rebuild

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.
aviatoredb
0

Comments

1 comment

Sort by
  • peter.peart
    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
    0

Add comment

Please sign in to leave a comment.