Upgrade production Server - SQL 2005 to SQL 2008 - inplace upgrade

  • Hi All,

    Can I confirm that I have the process correct and that I have not missed anything ?

    I am currently running SQL Server 2005 and want to upgrade to 2008/R2 -

    I am running several databases, with triggers and Stored Procedures - also Maintenance Tasks.

    So ...

    Backup the Databases

    Backup / Document Triggers

    Backup / Document Stored Procedures

    Backup / Document Maintanance Tasks

    Backup / Document Agent Jobs

    Install Sql 2008 as an upgrade

    Check DB integrity

    Check T / SP / MT / AJ from above

    check ERP system - functions in the same way and privilages have not been compromised during the upgrade.

    I think this should cover it ?

    ________________________________________________________________________________________________
    Regards
    Steve
    SQL 2008 DBA/DBD - MCTS/MCITP

    Please don't trust me, test the solutions I give you before using them.

  • Might I suggest using the UPGRADE ADVISOR and carefully reviewing the results

    upgrade advisor is available at;

    http://www.microsoft.com/en-us/download/details.aspx?id=11455

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • After running the advisor all looks well.

    Have run the upgrade on the test envoironment and again that has worked well - so planning on doing the Production server.

    A very easy process by Microsoft.

    ________________________________________________________________________________________________
    Regards
    Steve
    SQL 2008 DBA/DBD - MCTS/MCITP

    Please don't trust me, test the solutions I give you before using them.

  • Did you test your software against SQL2008? There were some T-SQL changes on SQL2008 and deprecated features. You need to ensure your T-SQL code behind will also work or was changed accordingly.

    A useful link:

    http://msdn.microsoft.com/en-us/library/ms143532(v=sql.100).aspx

    I actually remember few years ago, when I helped with an in-place upgrade, an old MS style join got broken in the code. I do not remember if it was when moving from 2000 to 2005 or 2005 to 2008. Long story short, the code was not tested by the developers and those joins stopped working.

  • Hi - yes the software is fully compatible with 2008 and 2012 - there are no changes out the box as it runs on 2005 ->

    I have checked my scrips and generated views - without any issues - so am happy.

    Thanks

    ________________________________________________________________________________________________
    Regards
    Steve
    SQL 2008 DBA/DBD - MCTS/MCITP

    Please don't trust me, test the solutions I give you before using them.

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

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