Scribd Logo
Upload

Welcome to Scribd!

  • 31 views

    Upgrading SQL Server 2000 Cubesheet

    Uploaded by

    Ratu Tanpanya
    This document provides guidance on migrating from SQL Server 2000 to SQL Server 2012. It recommends first migrating to an intermediate version such as SQL Server 2008 R2, 2008, or 2005. It then provides links to guides for upgrading between each version. Additional resources are included on moving databases, logins, packages, and preparing applications for the migration.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Upgrading SQL Server 2000 Cubesheet

    Uploaded by

    Ratu Tanpanya
    31 views3 pages
    This document provides guidance on migrating from SQL Server 2000 to SQL Server 2012. It recommends first migrating to an intermediate version such as SQL Server 2008 R2, 2008, or 2005. It then provides links to guides for upgrading between each version. Additional resources are included on moving databases, logins, packages, and preparing applications for the migration.

    Original Description:

    Upgrade SQL Server

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides guidance on migrating from SQL Server 2000 to SQL Server 2012. It recommends first migrating to an intermediate version such as SQL Server 2008 R2, 2008, or 2005. It then provides links to guides for upgrading between each version. Additional resources are included on moving databases, logins, packages, and preparing applications for the migration.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    31 views3 pages

    Upgrading SQL Server 2000 Cubesheet

    Uploaded by

    Ratu Tanpanya
    This document provides guidance on migrating from SQL Server 2000 to SQL Server 2012. It recommends first migrating to an intermediate version such as SQL Server 2008 R2, 2008, or 2005. It then provides links to guides for upgrading between each version. Additional resources are included on moving databases, logins, packages, and preparing applications for the migration.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 3

    SQL Server 2000

    End of Support Cube Sheet (April 9, 2013)

    SQL Server 2012 – A Brief Overview

    Why SQL Server 2012? SQL Server 2012 provides Mission Critical Confidence with greater uptime,
    blazing-fast performance and enhanced security features for mission critical
    workloads; Breakthrough Insight with managed self-service data exploration
    and stunning interactive data visualizations capabilities; Cloud On Your Own
    Terms by enabling the creation and extension of solutions across on-premises
    and public cloud. SQL Server 2012 will be available in three main editions: For
    more info check

    http://microsoft.com/sql
    http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx
    Support Lifecycle End of Mainstream: July 2017
    End of Extended Support: July 2022
    Case Studies Edgenet
    BetonSoft
    Department of Special Investigation (Thailand)

    Upgrade Guide SQL Server 2012 Upgrade Technical Guide


    Evaluation Edition http://www.microsoft.com/en-in/download/details.aspx?id=29066
    Express edition
    Quick links Hardware/SW requirements
    Discontinued features
    Behavior Changes to SQL Server Features in SQL Server 2012
    SQL Server 2012 Setup just got smarter
    Latest Service Pack KB
    Using SQL Server in Windows 8 and Windows Server 2012 environments
    Some Known setup issues
    Learn More Learning center resources for SQL Server 2012
    Migrating from SQL Server 2000 to SQL Server 2012
    Step 1: Ensure your SQL Server is ready for migration. Ideally you should be on SQL Server 2000
    SP4 to proceed with the migration. For additional information refer to:

     321185 How to determine the version and edition of SQL Server


     290211 How to obtain the latest SQL Server 2000 service pack

    Step 2: Migrate to an intermediate version (SQL 2005, SQL 2008 or SQL 2008 R2)

    Note: Use one of the guides as appropriate for your environment:

    Intermediate
    SQL Server 2008 R2 SQL 2008 SQL 2005
    Version 

    SQL 2000 SP4 and later SQL 2000 SP4 and later SQL 2000 SP3 and later
    You need to be on
    builds builds versions

    http://msdn.microsoft. http://msdn.microsoft.c http://msdn.microsoft.co


    For upgrading com/en- om/en- m/en-
    instructions us/library/bb677622(v= us/library/bb677622(v=s us/library/ms144245(v=S
    sql.105).aspx ql.100).aspx QL.90).aspx

    http://www.microsoft. http://www.microsoft.c
    If you need an com/en- om/en-
    Not Available
    evaluation version in/download/details.as us/download/details.asp
    px?id=6362 x?id=8850

    Step 3: Migrate from the intermediate version (from Step 2) to SQL Server 2012 using the information
    available at: Supported Version and Edition Upgrades.
    Additional information

    Topic Description
    How to copy DTS 2000 packages between servers (and from SQL 2000 to
    SQL 2005 and SQL 2008)
    Moving DTS Packages
    DTS-xChange

    http://technet.microsoft.com/en-us/library/ms143179.aspx
    Getting your apps ready
    Discontinued Database Engine Functionality in SQL Server
    (use version picker tool at
    Behavior Changes to SQL Server Features in SQL Server 2012
    the top)
    SQL 2000 to 2008 migration guide from Dell

    Use Upgrade Advisor to Prepare for Upgrades


    Migrating SQL Server 2000 user databases to SQL server 2012

    918992 How to transfer logins and passwords between instances of


    SQL Server

    2009160 High CPU utilization may occur with your queries on SQL
    Server 2005 and SQL Server 2008 servers compared to SQL Server 2000
    Quick referrals
    Back Up and Restore of System Databases (SQL Server) (use version
    picker tool at the top for the version that is applicable to your
    environment).

    Moving User databases

    Moving SharePoint databases


    Data Migration to Windows Azure SQL Database: Tools and
    Migrating to cloud
    Techniques
    Tips for Migrating Your Applications to the Cloud
    SQL Database Migration Wizard v3.9.9 & v4.0.12

    SQL Server 2008 R2


    Express editions SQL Server 2008
    SQL Server 2005

    You might also like