Post reply

Transfer from non-Case Sensitive to Case Sensitive

  • August 23, 2004 at 6:07 pm

    #102169

    Sql Server 2000

    I have a DB with about 80 views.  I am trying to transfer the Views from one Server to another.

    Due to Corporate Policy  I cant' change the new server is Case Sensitive whereas the old one wasn't. 

    I scripted all the my views (into one file) and of course am running into two problems trying to re-create them

    1- The Case problem

    2 - Sql Server's lame brain why of sequencing the views.. quite a few of my views depend on each other.

    How can I solve these issues in an easy way?

  • August 24, 2004 at 2:28 pm

    #520413

    You may script them, paste to QA in new server, change all of them to lower case by highting them and pressing shift+ctrl+L. If your table was lower case in old server but now upper case, you have no choise to change them manually.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply