Post reply

Migration detail for SQL SERVER 2000 TO SQL SERVER 2012

  • April 3, 2013 at 4:12 am

    #291767

    HI

    i need help for migration the coding in sql server 2000 to sql server 2012 . regarding this what are the step taken from initial or any basic configuration need to setup before migration to step up step action to final stage

    please advise or guide me

    with regards

    sankaripr

  • April 3, 2013 at 6:13 am

    #1603116

    I would suggest you start your upgrade task using the Upgrade Advisor

    here is a link that will assist you in starting your upgrade

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

    The above reference starts with assistance in upgrading from 2000 to 2005, but it also contains links, for upgrading from 2005 to 2008 and from 2008 to 2012.

    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]

  • April 3, 2013 at 6:42 am

    #1603127

    Hi Ron

    i really thanks for regarding helping for this migration

    thank lot

  • April 8, 2013 at 5:49 am

    #1604345

    When you know what Upgrade Advisor has found, a good next step is to set up a SQL 2012 instance in your development environment and run all your applications on it. This should show up problems that cannot be found by Upgrade Advisor.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

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

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