Post reply

Changing Database Names

  • June 6, 2019 at 12:00 am

    #3632274

    Comments posted to this topic are about the item Changing Database Names

  • June 6, 2019 at 5:20 am

    #3650668

    Whether you use the old or new method, there's a whole lot more to it if you really want to do it right.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • June 6, 2019 at 5:44 am

    #3650672

    Jeff Moden wrote:

    Whether you use the old or new method, there's a whole lot more to it if you really want to do it right.

    Agreed

    However, it is a good question. really made me think...

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • June 6, 2019 at 1:41 pm

    #3650763

    hmmm -- I have used sp_renamedb in the past without any issues, and it still works. I think it is wrong to post multiple answers that are both OK.  I now realize that the stored procedure is in maintenance mode, but sometimes you need to cut us old timers some slack.

     

    OK -- now I went back and reread the question.  At first I did not see the "in a way that will be supported in the future".  My bad!

    • This reply was modified 5 years, 1 month ago by  mike.sortino.

Viewing 4 posts - 1 through 3 (of 3 total)

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