sQL 2008 VS 2012

  • We are moving from SQL 2008 to 2012. What are the big differences... As we have lot of packages around 30-40. To migrate these packages into 2008, what should be kept in mind and what kind of issues i could face.

    regards

    Shaun.

  • Shaun2012 (11/12/2013)


    We are moving from SQL 2008 to 2012. What are the big differences... As we have lot of packages around 30-40. To migrate these packages into 2008, what should be kept in mind and what kind of issues i could face.

    regards

    Shaun.

    By "packages" are you referring to SSIS packages? And by "To migrate these packages into 2008", do you mean SQL Server 2012?

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • Shaun,

    Here's a prior post with a few links about this topic:

    http://www.sqlservercentral.com/Forums/Topic1313095-391-1.aspx

    Mark

  • SSIS 2012 has two deployment models: package deployment model and project deployment model.

    Package deployment model is exactly the same as SSIS 2008, so if you choose this model your migration will be easy.

    Project deployoment model is different as it works with parameters and environments. It has its advantages but you'll have to migrate your packages (especially configurations and execute package tasks). There's a wizard that assists you with this.

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

  • reply thank u guys.. its been lot of help...

    Shaun

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

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