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

table renaming...

benblobenblo Posts: 13
edited June 27, 2006 1:37PM in SQL Compare Previous Versions
That may be an old & annoying topic, but is there any way you could manage table renaming in Sql Compare (schema, not data)?
I'm not talking about doing this automatically, but mapping manually. I figure, since you have all the basis for scripting, comparing and such, adding a few options to manually map stuff like table & column names shouldn't be THAT bad! (but then again, I could figure wrong ;)).
Cheers, keep up the good work!


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

    Thanks, we sould like to implement something better to handle the renaming of objects. Currently, the software relies of the object name in the data definition to match the name in the sysobjects (sys.objects) system table. That relationship breaks if you use sp_rename or Enterprise Manager to rename a table.
This discussion has been closed.