Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SQL2000 to SQL2008 db migration

Answered SQL2000 to SQL2008 db migration

  • Tuesday, January 22, 2013 6:54 AM
     
     
    Sign In to Vote
    0

    Hi All,

    we are migrating one of our SQL 2000 database to new SQL 2008 R2 server.
    So to check migration issues, I executed SQL 2008 upgrade adviser for SQL2000 database.

    Upgrade adviser showed me very less issues. So I manuallu checked some SQL2000 db objects and found it is not reporting all issues. Like one of the SP is using non-ansi join (=*) but it is not reported by upgrade adviser.

    anyone knows why this is not coming in upgrade adviser report? is there any alternative tool available like upgrade adviser?

     

All Replies

  • Tuesday, January 22, 2013 11:47 AM
    Moderator
     
     
    Sign In to Vote
    1

    Hello,
    Please download SQL Server 2008 Upgrade Advisor with SP2 applied from the following link:

    http://www.microsoft.com/en-us/download/details.aspx?id=6375 

    You can try with SQL Server 2008 R2 Upgrade Advisor with SP1 from the following link:

    http://www.microsoft.com/en-us/download/details.aspx?id=26728

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

     
  • Tuesday, January 22, 2013 4:48 PM
     
     
    Sign In to Vote
    0

    I have downloaded from same link. It didnt help :(

     
  • Tuesday, January 22, 2013 5:07 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    Please create a trace using SQL Server 2000 Profiler and provide that trace to Upgrade Advisor. Execute those stored procedures while the trace is created.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

     
  • Wednesday, January 23, 2013 5:06 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Harish,

    SQL Server 2000 with Service Pack 4 is supported to upgrade to SQL Server 2008 R2. Please apply SQL Server Service Pack 4 before you upgrade.

    Please refer to Version and Edition Upgrades: http://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx.

    Thanks.

    Maggie Luo
    TechNet Community Support

     
  • Wednesday, January 23, 2013 11:54 AM
     
     
    Sign In to Vote
    0
    Can you please have an go through the checklist and White paper of Overview: Upgrading from SQL Server 2000 to  SQL Server 2008(type in google engine).

    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.