Database access by machines running SQL Servers 2005 32-bit and 64-bit

Hello

We have 1 machine running SQL Server 2005 x64 (64 bit). The other machine is backing this SQL Server up. It is a 32-bit machine, so it requires (?) a 32-bit version of SQL Server 2005.

Would this back-up machine work correctly on a database previously managed by a 64-bit machine and vice versa.

Thank you!

Yes, in terms of connection and administration you won′t feel any difference. But you only can install 32bit software on a 32bit system.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

If my DEV box is 32 bit and my PROD box is 64 bit:

can I deploy (or migrate) from DEV to PROD. The DEV box would have the 32bit SQL Server and the PROD would have the 64 bit SQL server. But if I deploy what I wrote and created there on 32 bit will it run on the 64 bit?

CLR stored procedures?|||No, the things that were developed on the DEv machine can be deployed without any problem on the production machine as from your description. On the Prod system the 64bit framework will take care of the assemblies.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de