Post reply

Converting SQL Server 2000 database into 2005 format

  • February 10, 2006 at 4:51 pm

    #110975

    Hello!
     
        We have attached our 500GB SQL Server 2000 databases on 2005 server. The process took literally took 10 seconds. I was wondering if databases should undergo low level conversion when moved to 2005 environment in order to take full advantage of new features. Will simply attaching the databases do the job?
    We are planning to switch databases to 9.0 compatibility mode. I am aware certain features have been deprecated. Besides that I am concerned we won't be able to take full advantage of new 2005 features unless we do low level conversion. If this is the case, is there a way to initiate this process after attaching  the database ?
     
    Any help is greatly appreciated,
    Igor

  • February 11, 2006 at 9:27 pm

    #620327

    I saw this answered in another forum so, I thought I'd provide the URL here so everybody in this forum can benefit, as well...

    http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/3d3e05ce8ce60090

  • February 12, 2006 at 10:27 am

    #620338

    This is the same questions answered by Microsoft MVP

     

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

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