Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Upgrading from SQL Server 2005

  • 21-05-2014 8:43am
    #1
    MagicMarker
    Banned (with Prison Access) Posts: 32,865 ✭✭✭✭


    I've been asked to make a case for upgrading from SQL 2005, and as I've only ever used 2005, I'm here to ask you fine people for advise.

    From a reporting perspective only, what would be the advantages of upgrading? I would assume there's better/broader functionality, maybe better performance? Also would it be best to take a single step up to 2008, or move up to the newest version?


Comments

  • #2
    amen
    Registered Users, Registered Users 2 Posts: 2,781 ✭✭✭amen


    Best bet is to start reading the MS White papers on upgrading SQL Server. There are numerous advantages but to me the most important is that you are running on the most current version of SQL Server. With SQL Server 2014 available you are now 4 versions behind the current version.

    That said the licensing model has changed so you may need to pay more.

    If you are migrating you need to look at the depreciated SQL commands, features etc and think about removing them now.

    Make sure you read up on the various ways to migrate.

    Make sure you practice the migration several times in a test environment and test all applications in the test environment to ensure that they work with the version of SQL Server you select.

    If you are migrating you will want to migrate the OS as well to the newest available OS.

    You may as well get more memory (as much as you can afford at least 1/4 of the DB size) and new CPUs.


  • #3
    MagicMarker
    Banned (with Prison Access) Posts: 32,865 ✭✭✭✭MagicMarker


    Hey, thanks for that.

    The server it's running off is solely used for reporting, there is actually no applications dependent on it. TBH from reading online I'm not sure if it's even worthwhile upgrading. The reporting doesn't get a whole lot of usage, maybe 130-180 report executions a day, most of which are subscriptions. The SSIS packages all run overnight basically so wouldn't effect performance during working hours.

    I'm just not sure the cost/hassle of upgrading outweighs the benefit!


  • #4
    Beano
    Closed Accounts Posts: 3,357 ✭✭✭Beano


    MagicMarker wrote: »
    Hey, thanks for that.

    The server it's running off is solely used for reporting, there is actually no applications dependent on it. TBH from reading online I'm not sure if it's even worthwhile upgrading. The reporting doesn't get a whole lot of usage, maybe 130-180 report executions a day, most of which are subscriptions. The SSIS packages all run overnight basically so wouldn't effect performance during working hours.

    I'm just not sure the cost/hassle of upgrading outweighs the benefit!

    TBH if the server is just used for reporting then i cant see any massive incentive to upgrade technology wise. 2008R2 has some new reporting features like sparklines and the like but they are just nice to haves. I'd be tempted to sit tight on what you have until you need to upgrade.


Advertisement