SQL Server Performance

32 bit vs. 64 bit SQL Server 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by bhushank21, Jul 18, 2007.

  1. bhushank21 New Member

    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
  2. MohammedU New Member

  3. satya Moderator

    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.

Share This Page