Post reply

Moving from sql-2000 x32 to sql-2005 x64

  • October 13, 2006 at 9:03 am

    #115883

    I'm starting to migrate sql2000 x32 to sql-2005 x64 with OS server 2003 x64 on a different box. My question - what is the best way to migrate the databases between the boxes?

    thanks

  • October 13, 2006 at 10:36 am

    #665792

    Steve--

     

    I am in process of doing the same but from SQL-2000 to SQL 2005 32 bit version.  You can probally copy the database over with DTS from what I've read off this site or perform a detach, copy the mdb and ldb files pertaining to your database then reattach on SQL-2005 machine.  I am in process of doing a migration and am having problems with my logins.  there was an excellent tool for doing this in SQL-200 @ http://www.dbmaint.com.

     

    Hope all is well!

     

    SQL2DAY

  • October 13, 2006 at 10:43 am

    #665793

    Thanks

    I was concerned with 32 to 64 -- it depends on when the mdb is converted. I also read you can backup / restore and the restore converts but if you do the detached / copy when does the convert happen? I'll start with the copy to see what happens on start up.

    Steve

  • October 13, 2006 at 1:13 pm

    #665823

    Yes it sounds like your heading in the right direction from all you have read.  The fact that you're upgrading from 32  to 64 bit may or may not have issues regarding detach/attach.  Did you see the tech reference for upgrading to SQL-2005?  Hope this helps for your situation--

     

    http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

     

    SQL2DAY

  • October 13, 2006 at 1:22 pm

    #665827

    Thanks

    Captured that link for the future.

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

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