Force table rebuild

aviatoredb

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.

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