Renaming Tables

dlgrossdlgross Posts: 17
edited August 26, 2005 12:23PM in SQL Compare Previous Versions
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

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
This discussion has been closed.