32 bit vs. 64 bit SQL Server 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

32 bit vs. 64 bit SQL Server 2005

We are planning to migrate to 64 bit SQL Server 2005 with 64 bit OS on a production server.
Locally, all developers have 32 bit OS and 32 bit SQL Server 2005. I wanted to know what could possibly go wrong when we deploy the SQL code and SSIS packages that are developed in 32 Bit SQL Server 2005 to a 64 bit SQL Server 2005.
We cannot afford to have 64 bit in development environment. Thanks and Regards,
Bhushan
http://www.metacafe.com/watch/365213/wonder_what_you_are
Yes, you can deploy SSIS packages developed on 32 bit server without any issues…
You can also restore databases from 32 bit to 64 bit and vice versa… http://www.teratrax.com/articles/sql_server_64_bit.html
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1241693,00.html
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
No worries migrating the 32 bit to 64 bit as the database will be same between the bit versions, but make sure the service pack system is same in this case. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>