Converting SQL Server 2000 DB to 2005 DB

  • How do I convert a SQL Server 2000 database to a SQL Server 2005 database?

  • have you tried taking a back up and restoring it to your SQL 2005 instance, it's worked for me so far.

     

     

    regards,

    Mark Baekdal

    MSN m_baekdal@hotmail.com

    +44 (0)208 241 1762

    http://www.dbghost.com

    http://www.innovartis.co.uk

    Build, Comparison and Synchronization from Source Control = Database change management for SQL Server

     

     

  • The process worked for me too.

    However, you may still need to configure SQL suface area properly to make all your SPs work. Some features like xp_cmdshell is turned off by default

     

     

  • You shouldn't have any problems James, backups have been able to restore automatically since at least SS2K5 beta 2. Microsoft tend to get features like that working and stable first - no easy upgrade path means no sales, so it's a pretty essential feature.  Might be worthy of an article though (hint!) if you have the time to describe any problems you hit.


    Jon

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

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