32bit to 64bit
-
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)
-
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.
-
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