Visual Studio Tools for Database Professionals - Rename Refactoring Take II

In January 2007 I complained about the support for renaming fields in VS Tools for DB Professionals.

It looks they have a good solution for it in their latest CTP (look in the Refactoring section).

I did not find time to install VS2008 SP1 beta in a VM to then be able to install the VSTS 2008 Database Edition June CTP.

They say they do "Preservation of Intent", which I guess it's basically remembering the operations performed in the model (but I hope is something more sophisticated as it looks they got a patent for it).

This kind of approach usually has the problem of handling correctly the scenario where the user undid their actions. For example, a user can rename a column and then rename it back. Being smart about it is not that simple. This time my first test will be to do exactly that. I hope it does not end up renaming the column twice in the target database.

No Comments