What are the challenges you face when working across database platforms? Take the survey

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?


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1

    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.