Post reply

Baselining Database Code

  • November 28, 2012 at 8:39 am

    #151151

    I would like to find an easy way to baseline procedures, functions, etc for SQL Server 2005. We are contemplating taking the whole database and unencryping everything into a renamed database then opening all of it up 1 by 1 and saving it, then baselining through our document repository. I really hope there is a faster way of getting all that code baselined. We've had this stuff for over 10 years and it is monstrous and very database driven. :w00t:

    Thanks in advance for any suggestions,

    Becky

  • November 28, 2012 at 8:45 am

    #1563218

    Did you see the recent headline articles?

    http://www.sqlservercentral.com/articles/baselines/94657/

    http://www.sqlservercentral.com/articles/baselines/94656/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 28, 2012 at 12:23 pm

    #1563389

    Thanks definately useful but I was looking for a quick way to grab all the database code and put it into individual files. The purpose would be to baseline the database code in the document repository. MY DBA has been baselining the performance and things do seem to be getting better.

  • November 28, 2012 at 12:45 pm

    #1563402

    rebecca.moore.ctr (11/28/2012)

    Thanks definately useful but I was looking for a quick way to grab all the database code and put it into individual files. The purpose would be to baseline the database code in the document repository. MY DBA has been baselining the performance and things do seem to be getting better.

    ok if i'm reading you correctly, if you simply want to script out all the DDL definitions of every object, there's a really nice powershell script in this forum post which i recommend:

    http://www.sqlservercentral.com/Forums/Topic1240480-1351-1.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 28, 2012 at 2:46 pm

    #1563463

    Why not just right click on the database, select "tasks", "generate scripts", and select box to create 1 file per object?

    --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)

  • November 29, 2012 at 5:44 am

    #1563705

    That would work if all the code wasn't encrypted but that is along the lines of the answer I need. Thank You. It may end up being part of the process I'll have to use.

Viewing 6 posts - 1 through 5 (of 5 total)

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