none
Migrate my existing database from upper case to lower case

    Question

  •  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?

    Any help would be greatly appreciated.

    Thanks in advance.

    Monday, July 16, 2012 1:31 PM

Answers

  • hi,

    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

    UPDATE dbo.MyTableName
      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...

    regards


    http://www.asql.biz - DbaMgr2k - DbaMgr and further SQL Tools http://www.hotelsole.com/

    Monday, July 16, 2012 9:57 PM
    Moderator