32 bit sql sever to 64 bit sql server 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

There should not be any problem using 32-bit application that connects to 64-bit sqlserver. Sql management tool is 32-bit afterall.

The SPs, UDFs, etc. developed on 32-bit work the same on 64-bit. Sql data works interchangably between x64 and x86. This is the reason why you can safely take a backup from x86 and restore it to x64 server (and vice versa).