Force table rebuild
aviatoredb
Posts: 2
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.
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
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
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569