When a schema change requires a table to be dropped and recreated, SQL Compare automatically generates temporary tables to hold your data so nothing is lost during the migration.
SQL Compare 11 was released around 2013-2014 . It is now considered an "old version," but Redgate still provides documentation and installers for legacy users . Red Gate Sql Compare 11 Crack