Convert database from 32 to 64 bit sql server 2008

Question

We are in the process of moving databases from older 32-bit hardware running SQL 2005 to newer hardware with 64-bit SQL code. My question is that the database is automatically converted to 64-bit after it is reconnected to the new server or if it works in 32-bit mode on a 64-bit instance. Is there any way to tell?

Answer 1

Yes, you can simply detach and attach your database when upgrading from 32-bit to 64-bit Windows.

I did the x86-> x64 conversion in the past and had no problems.

No problem, because the storage level is the same for SQL x86 and x64.

Microsoft says here :

The format for storing data on SQL Server is the same in 64-bit and 32-bit environments. Therefore, attach work in 32-bit and 64-bit environments. A database that is separate from the server instance running in one environment can be attached to a server instance that runs in another environment.

So, to answer your question if you:

• Created database on x64 MS SQL Server
• Created a database on x86 MS SQL Server and moved it to x64 MS SQL Server

Both options # 1 and # 2 will result in the same completion state. There is no difference between the x86 database and the x64 database.

From 2005 to 2008, the compatibility mode is used. But for x86-x64 there is no difference.

Answer 2

In the database anyway, this is server software running on 32 or 64 bit. When you move a database from SQL2005 to SQL2008, it will be set to SQL2005 compatibility mode. To use the functions of SQL2008, you will have to change it to SQL2008. If there are some incompatibilities in your database, you can create another SQL2008 database and run SQL2008 SQL with the SQL2005 database from the SQL2008 database.