I want to detach a database from a 32bit Microsoft SQL 2005 environment and attach it to a 64bit Microsoft SQL 2008 environment.
The SQL Server on-disk storage format is the same in the 64-bit and 32-bit environments. Therefore, attach works across 32-bit and 64-bit environments. A database detached from a server instance running in one environment can be attached on a server instance that runs in another environment.
I was just wondering if there would be any limitations since the database was created in a 32bit environment?
Should I just bite the bullet and create a new database in SQL 2008 64bit and migrate the data, or can I get away with detaching and attaching?