I am creating an alter script with a pair of my models. In the alter script, one of the tables is being dropped and recreated, instead of having alter statements used to modify the table. I do not want the table dropped. I want the alter script to use alter statements instead to modify the table. Is it possible to do this?
Columns in the table have been renamed and TDM does not recognize renaming. For TDM, it is the same like dropping the column and creating a new one with a new name. To keep the right order, the only way to do that is to rename and create a new column in the alter script. Unfortunately, all the data of the renamed columns are dropped/lost during the data migration between the new and old tables, which is again caused by the fact that TDM doesn't recognize the renaming.
