Home Forums SQL Server 2005 Administering SQL 2005 32 bit to SQL 2008 R2 64 Bit. RE: SQL 2005 32 bit to SQL 2008 R2 64 Bit.

  • May 16, 2013 at 1:16 pm

    #1615977

    Doubtful on #3. The RDL format will be different too so you're looking at an RS Reports migration here too.

    The engins upgrade itself is pretty safe. Start with running Upgrade Advisor against the 2005 instance and address all feedback.

    32 to 64 bit has some extra challenges if you're reaching out to external resources from within the engine, e.g. OPENROWSET, Linked Servers, OLE Automation, xp_cmdshell, SQL Agent CmdExec steps, etc.

    Are you using SSIS anywhere? There are some 32 to 64 bit challenges there as well.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato