June 7, 2010 at 10:15 am
Is it possible to replicate a SQL2K5 database from 32bit to 64bit?
SOURCE: 32-bit versions of O/S & SQL2K5
Microsoft SQL Server 2005 - 9.00.3068.00 (Intel X86) Feb 26 2008 18:15:01 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
TARGET: 64-bit versions of O/S & SQL2K5
Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
June 8, 2010 at 7:59 am
rew-370421 (6/7/2010)
Is it possible to replicate a SQL2K5 database from 32bit to 64bit?SOURCE: 32-bit versions of O/S & SQL2K5
Microsoft SQL Server 2005 - 9.00.3068.00 (Intel X86) Feb 26 2008 18:15:01 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
TARGET: 64-bit versions of O/S & SQL2K5
Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Unfortunately you have to take every column, trigger and stored procedure and convert it into 64 bit using the sql 2005 64bit compiler.
😛
Seriously though there should be no issues doing this as the data is the same its just the software that it runs on top of.
June 8, 2010 at 8:05 am
Thanks for the reply, jbuchan.
You hand me scared for a minute! :unsure:
Now all I have to do is figure out how to setup replication. 😀
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply