Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2007
    Posts
    35

    Unanswered: SQL 32bit DB to a SQL x64bit DB Server

    I am going to test the migration of a 32bit SQL 2005 database to a SQL 2005 x64bit database server. Has anyone tried this? What can I expect? Will it work? Is there anythi I need to do?

    I was just going to detach the 32bit DB, copy yhe files to the 64 bit server and reattach it.

    Thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I have had no problems doing this. The 64-bit features mainly affect how SQL Server treats memory, and has no effect on how a database is stored on disk. I have even taken databases from 64-bit SQL Servers and successfully restored them to 32-bit SQL Servers.

  3. #3
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    I have done this, didn't really face any major problems.

    if there are any DSN's set up make sure they are replicated in the 32bit odbc admnistrator as opposed to the 64bit odbc administrator (yes there are two).

    Also if you have and DTS or whatever referncing data on Oracle then you may have problems with the PorgramFiles(x86) folder, but there is a workaround for this.

    Attach your databases and give it a whirl

  4. #4
    Join Date
    Oct 2007
    Posts
    35
    Yo said you did a "Restore" on them. How bout if you just did a file copy of the .mdf an .ldf onto the 64bit environment?

  5. #5
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    Personally I always think its better to do backup and restore rather than detach - copy - attach.

    But hey thats just me

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I prefer backup/restore as well. Nothing like having a fallback position ;-).

    I have also detached and attached dataabses from 32-bit to 64-bit. You can try this yourself with a dummy database. Create a database, put a table in it, detach, re-attach, and see what happens.

  7. #7
    Join Date
    Oct 2007
    Posts
    35
    OK, Thanks everyone.
    I appreciate the replies.

Posting Permissions

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