Portability of SQL Server applications between 32-bit and 64-bit versions of SQL Server?

I have an application that is currently working with a 32-bit SQL Server 2005 Standard Edition database. For reasons that I will not be logging on to, I need to move the database to the 64-bit version of SQL Server 2005 Standard running in the 64-bit Windows Server 2003 R2 data center.

Are there any migration issues that I should know about in application code, stored procedures, or SQL configuration? That is the equivalent of functionality on both platforms?

If there are functional differences, can you post a link to a document with migration planning tips?

+3
source share
2 answers

, . , . t-sql- (64- ; -).

, , - . C, 64- . .

, .

+2

, , , dtexec 32- SSIS , 64- Jet (Excel Access, ).

+1

All Articles