I want to migrate my existing database (Microsoft SQL Server 2005) from upper case to lower case so that any part of the script (stored procedure/constraints) shouldn't be break
What would be the feasible way to do this?
do you mean to modify alll your data do uppercase or to modify all your "scripts" to uppercase, or, "deeper" to modify all your object's names to uppercase?
the second is not a problem, as you just should modify not the "syntax" but the actual names of the script's involved objects... so it a referenced table is named like "dbo.MyTableName" you should always use that case form and not transform it to "dbo.mYtAblenAme"
or the like, as different settings in collation can make the statement(s) fail...
for the data modification, you have to UPDATE your tables like
SET ColVarChar = UPPER(ColVarChar),
OtherColVarChar = UPPER(OtherColVarChar),
for every table and, for each of them, for every column hosting varchar/char/nvarchar/nchar data..
for the last, object's name modification, I'd not...
http://www.asql.biz - DbaMgr2k - DbaMgr and further SQL Tools http://www.hotelsole.com/