Hi guys,

is the mrgration process to 64 bit seamless, or not.

Can someone please give me the proper steps for that

Thks 

I have Migrated from 32 bit SQL 2000 to 64 bit SQL 2005. The changes were all related to SQL2000 ro SQL 2005. I haven't seen any difference in the database based on 32bit. After migration I have taken the backup and restored in 32 bit servers. (Even Detach & attach) They all worked fine. I haven;t set the replication that way, So I am not sure how that works.
You can go with Detach and Attach (Find the files of a database, detach the database, copy the files to 64 bit server, attach the database)

Nothing more difference as you do a backup/restore or detach/attach process, before that make sure to reindex all the indexes and also after restore/attach on 64 bit server.

http://sql-server-performance.com/Community/forums/p/25061/139282.aspx fi

hi,

i have tested a migration from SQL 2005 Std x32 running on a windows 2003 x32, to a Windows 2008 x64 with an SQl Server Std x64. Just a simple backup and restore. everything runs smoothly as mentionned by satya above.

thanks