Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    69

    Unanswered: Migrate from 2000 to 2005

    Is there a tool available (or planned) to migrate SQL Server 2000 database to SQL Server 2005 ? I came across this (http://www.timespring.net/TS_TD_SQL0...-464&ad=524331) but are there any other tools ?

    Has Microsoft planned anything of its own for this ?

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    http://www.microsoft.com/downloads/d...displaylang=en

    Looking for something like this ?? Moreover, SQL Server 2005 will contain a upgrade wizard AFAIK.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Apr 2004
    Posts
    69
    Thanks for the response. Yes, I went through (and even tried) SQL Server Ugrade advisor. But not sure if Microsoft has plans to ship "Upgrade Wizard" kind of utility as shipped with SQL Server 2000. I couldn't find any reference to such utility being planned in their site.

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Quoting from the new version of the HOLY BOOK (BOL 2005)
    Upgrading to SQL Server 2005 from a previous SQL Server version is supported by the SQL Server 2005 Setup program. You can also migrate databases from previous SQL Server versions to an instance of SQL Server 2005. Migration can be from one SQL Server instance to another on the same computer, or from a SQL Server instance on another server. Migration options include use of the Copy Database Wizard, Backup and restore functionality, use of the SQL Server 2005 Integration Services Import and Export Wizard, and bulk export/bulk import methods.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  5. #5
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    More information on how to upgrade : http://msdn2.microsoft.com/en-us/library/default.aspx.

    Web Version of the new BOL can be found here.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •