Migration from Sql Server 2008 sp1 to r2

  • Hi,

    We have a requirement of migrating the Sql Server from sp1 to r2. So, any idea what will be impact in the modifying the existing packages, SSRS reports and SSAS?

    Thanks,

    Kapil

  • Expect to be minimal.

    Install a trial version and test the migration process. Unless you are using depreciated function you should be fine.

    That's where upgrade advisor is your friend!

  • Ninja's_RGR'us (5/4/2011)


    Expect to be minimal.

    Install a trial version and test the migration process. Unless you are using depreciated function you should be fine.

    That's where upgrade advisor is your friend!

    Thanks for the info but the problem is we can't install trial version and want to do analysis w/o it.

    Let me know if anyone has tried this migration....

  • I also expect no significant troubles.

    BIDS 2008 R2 is the same as BIDS 2008, so everything should be compatible.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • kaps.manshani (5/4/2011)


    Ninja's_RGR'us (5/4/2011)


    Expect to be minimal.

    Install a trial version and test the migration process. Unless you are using depreciated function you should be fine.

    That's where upgrade advisor is your friend!

    Thanks for the info but the problem is we can't install trial version and want to do analysis w/o it.

    Let me know if anyone has tried this migration....

    How are you going to analyse without testing? Makes no sense.

  • Thanks guys.. 🙂

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

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