Post reply

Changing to SQL server 05 64 bit version question?

  • June 15, 2006 at 3:28 am

    #169170

    I am currently running SQL 2000 32 bit version on a 32 bit server. I will buy a 64 bit server and have SQL 05 64 bit version installed. If I want to migrate all the data from my current server to the new 64 bit server, what is the critical procedure for this, is there anything I should be concerned before the migration? What I concern about is there are major or minor impact on the data.

    Please let me know if there are anyone done this before.

     

  • June 15, 2006 at 3:52 am

    #643895

    Ken,

    In terms of migrating your data from a 32 bit SQL Server to a 64 bit SQL Server there shouldn't be anything to worry about. Just treat it like a normal migration.

    The databases themselves (and data contained within them) are unchanged between 32 and 64 bit. The only difference is the engine is 64 bit.

    In terms of the migration path you choose you have a number of options. In my case I just did a straight backup copy and restore from the old 32 bit system to the new 64 bit system.

    Had both systems running side-by-side for a while making sure that all was well and then switched off the old system. Nothing that you wouldn't do as a matter of course on any migration.

    Karl
    source control for SQL Server

Viewing 2 posts - 1 through 1 (of 1 total)

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