Renaming Tables

dlgross

How can I rename a table in my development db and have the changes propagate/sync into my test DB without dropping the table in the testDB. This would cause me to lose my testing data. The scripts seems to do a drop/create is there any way to have it automatically do an Alter instead? Am I missing something?

Brian Donahue

Hello,

SQL Compare cannot handle table renames because there is no way of knowin gthat the object was renamed and is simply not a whole new object. SQL Compare will drop a renamed table unless you specifically deselect it.