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?
Comments
1 comment
-
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.
Add comment
Please sign in to leave a comment.