Post reply

Migrating databases from 32 bit SS 2000 to 64 bit SS 2005

  • January 30, 2008 at 9:09 am

    #773366

    I don't have any replication in my environment (luckily from the sounds of it), but I do remember in one of the upgrade Technet webcasts them mentioning that there was a particular order to upgrade your replication partners in. I also found this information in BOL that might be helpful for you:

    How to: Upgrade Replication Scripts (Replication Transact-SQL Programming)

    http://msdn2.microsoft.com/en-us/library/ms146934.aspx

  • January 30, 2008 at 9:28 am

    #773382

    Hey,

    One issue I came up against not long ago, was extended stored procedures based on C++, which were compiled using a 32-bit compiler and this had to be re-compiled, as customer still required the funcationality provided in the extended proc. Thereafter, extended proc. worked fine.

    As already suggested, test, test and test migration again.

    Good Luck,

    Phillip Cox

  • January 30, 2008 at 9:29 am

    #773383

    I know, I already read this article. What I have done is recreating replication at SQL 2005 level. My issue is on merge replication because here I have some Rows Filters and Articles which I have added its manually. But I've got the above error.

    In Theory, theory and practice are the same...In practice, they are not.

  • January 30, 2008 at 9:31 am

    #773384

    I forgot to say that all of databases are on 80 compatibility level because my ERP client wants that.

    In Theory, theory and practice are the same...In practice, they are not.

  • April 9, 2008 at 4:17 am

    #800259

    Thx a ton!!Joe;)

Viewing 5 posts - 16 through 19 (of 19 total)

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