Post reply

sQL 2008 VS 2012

  • November 12, 2013 at 8:06 am

    #279985

    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.

  • November 12, 2013 at 1:14 pm

    #1665857

    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

  • November 12, 2013 at 1:14 pm

    #1665858

    Shaun,

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

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

    Mark

  • November 12, 2013 at 1:28 pm

    #1665864

    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

  • November 13, 2013 at 7:27 am

    #1666079

    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