Migrating 32-bit SQL to 64-bit SQL - Any issues?

  • Has anyone had any issues migrating a SQL-2005/2008 instance from 32-bit SQL (and O/S) to 64-bit SQL (and O/S)?

    Anything to watch out for during and after the migration?

    Thanks for any input!

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • memeoy configuration and drivers if you are usiing linked server. there are seperate drives for 64 bit. other than that it should not give trouble

    :crazy: :alien:

    Umar Iqbal

  • umar iqbal (3/25/2009)


    memeoy configuration and drivers if you are usiing linked server. there are seperate drives for 64 bit. other than that it should not give trouble

    Thank you for the input.

    Can you elaborate on the drivers bit?

    Do I need to install new data providers for linked-server access?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • 32 bit driver for oracel and syabse would not work here. if you are replicating data to or from other platform.

    :crazy: :alien:

    Umar Iqbal

  • umar iqbal (3/25/2009)


    32 bit driver for oracel and syabse would not work here. if you are replicating data to or from other platform.

    Thanks, we are actually only using linked servers to other SQL-Server instances.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply