we recently moved our database from one version to another version. we are planning to do column name changes to most of the fields. is there a way i can do using a script.
Please recommend some ideal case on how to go with this approach
Changing from one version of SQL Server to another should not require you to do any column name changes. Is there some other reason why you want to do that? If you change the names, any references to those columns in views, stored procedures etc. would need to be changed. So it is a process that requires lot of care, attention and testing.
For this purpose we use RedGate SmartRename, which is part of SQL Refector tool.It will rename all reference objects in a smart way, to ensure database integrity.
Column Name Changes
Posted - 10/15/2012 : 09:55:56
