I am trying to deploy changes to tables from one database to another as part of development. SQL Compare insists on creating temporary tables in the target database, putting the data in them, and then trying to insert the data back into the new tables (which now have different types/names for columns).
I cannot find an option to turn off the preservation of existing data.
I want to deploy my schema changes while discarding any existing data if present. (It is called SCHEMA compare after all!) I don't understand why there isn't an option to ignore data currently in target tables and just drop them.