32-bit to 64 bit migration of SQL Server 2005 (Deployment)

Hi

Do we need to perform any special checks when we deploy SQL Server application developed using 32 bit SQL 2005 Edition in 64 bit SQL 2005 Edition?

To my understanding, 64 bit SQL Server 2005 provides better memory management and provides high performance when compared to 32 bit and it should not be an issue in deploying the application developed in 32 bit SQL Server 2005 in 64 bit environment.

Any help/hints on deploying in 64 bit SQL Server (for a product[SPs, TSQL Stmts] developed using 32 bit SQL Server) is appreciated.

Thanks

Kart

Hi,

Take a look at the following Knowledge Base Article:

http://support.microsoft.com/kb/314546/

-Vikram