From: Raj on 1 Jul 2010 07:15
Does MS SQL 2008 support refactoring?!
Ex: Changing a column name or data type of one column in one table will
reflect the changes in all the tables, stored procedures ...
What a feature!
From: Jeroen Mostert on 1 Jul 2010 14:44
On 2010-07-01 13:15, Raj wrote:
> Does MS SQL 2008 support refactoring?!
> Ex: Changing a column name or data type of one column in one table will
> reflect the changes in all the tables, stored procedures ...
No. Something like that would be useful while you're developing a database
design, but it would be an absolute nightmare on a production server. You
would essentially need to stop all traffic to the database while you figure
out what changes to issue. Even then, things like dynamic SQL or even simple
client-side queries would inevitably break, and renaming constraints
automatically isn't possible unless you adhere to a naming scheme. That's
not even touching on the issue of data loss when changing a column's data type.
Doing it *without* issuing a global lock and still not violate data
integrity would be even more costly. As in, impossible-to-justify costly.
> What a feature!
For a design tool, yes. For a database server, not really. Although a full
installation of SQL Server includes Management Studio, which has some design
features, it can't be considered a serious aspect.