Capatibility between 32 bit and 64 bit SQL Server 2000

Is SQL Server 2000 64-bit edition 100% compatible with SQL Server 2000
32-bit edition? I don't believe there would be any problems with us moving
to the 64-bit version, but my supervisor is a bit nervous because a previous
upgrade of our Dispatch software through a fit when we upgraded to a new
version.Hi Ben,
Would you please explain the "compatible" means in detail? Based on my
knowledge, x64 edition is totally the same sa 32bit edition except more
powerful performance.
Check following article:
Features Supported by the Editions of SQL Server 2005
http://msdn2.microsoft.com/en-us/library/ms143761.aspx
Let me know if you still have any concerns.
Thanks.
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>From: "Ben Mullen" <bmullengb@.nospam.nospam>
>>Subject: Capatibility between 32 bit and 64 bit SQL Server 2000
>>Date: Wed, 20 Sep 2006 17:47:53 -0500
>>Lines: 7
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
>>X-RFC2646: Format=Flowed; Original
>>Message-ID: <uiw#SbQ3GHA.4228@.TK2MSFTNGP06.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: 198.150.66.2
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP06.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:445761
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Is SQL Server 2000 64-bit edition 100% compatible with SQL Server 2000
>>32-bit edition? I don't believe there would be any problems with us
moving
>>to the 64-bit version, but my supervisor is a bit nervous because a
previous
>>upgrade of our Dispatch software through a fit when we upgraded to a new
>>version.
>>|||Specifically I was refering to all of our tables, saved queries, and ODBC
connection to our client programs.
"Vincent Xu [MSFT]" <v-xuwen@.online.microsoft.com> wrote in message
news:PvGRqtS3GHA.4548@.TK2MSFTNGXA01.phx.gbl...
> Hi Ben,
> Would you please explain the "compatible" means in detail? Based on my
> knowledge, x64 edition is totally the same sa 32bit edition except more
> powerful performance.
> Check following article:
> Features Supported by the Editions of SQL Server 2005
> http://msdn2.microsoft.com/en-us/library/ms143761.aspx
> Let me know if you still have any concerns.
> Thanks.
>
> Best regards,
> Vincent Xu
> Microsoft Online Partner Support
> ======================================================> Get Secure! - www.microsoft.com/security
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties,and confers no rights.
> ======================================================>
> --
>>From: "Ben Mullen" <bmullengb@.nospam.nospam>
>>Subject: Capatibility between 32 bit and 64 bit SQL Server 2000
>>Date: Wed, 20 Sep 2006 17:47:53 -0500
>>Lines: 7
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
>>X-RFC2646: Format=Flowed; Original
>>Message-ID: <uiw#SbQ3GHA.4228@.TK2MSFTNGP06.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: 198.150.66.2
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP06.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:445761
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Is SQL Server 2000 64-bit edition 100% compatible with SQL Server 2000
>>32-bit edition? I don't believe there would be any problems with us
> moving
>>to the 64-bit version, but my supervisor is a bit nervous because a
> previous
>>upgrade of our Dispatch software through a fit when we upgraded to a new
>>version.
>>
>|||Hi Ben,
If so, I think you don't need to worry about anything. Because they are
compatible for sure!
Thanks.
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================
Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>From: "Ben Mullen" <bmullengb@.nospam.nospam>
>>References: <uiw#SbQ3GHA.4228@.TK2MSFTNGP06.phx.gbl>
<PvGRqtS3GHA.4548@.TK2MSFTNGXA01.phx.gbl>
>>Subject: Re: Capatibility between 32 bit and 64 bit SQL Server 2000
>>Date: Thu, 21 Sep 2006 07:51:58 -0500
>>Lines: 68
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
>>X-RFC2646: Format=Flowed; Original
>>Message-ID: <#ATq$yX3GHA.4648@.TK2MSFTNGP04.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: 206-40-98-90.papertransport.com 206.40.98.90
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:445816
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Specifically I was refering to all of our tables, saved queries, and ODBC
>>connection to our client programs.
>>"Vincent Xu [MSFT]" <v-xuwen@.online.microsoft.com> wrote in message
>>news:PvGRqtS3GHA.4548@.TK2MSFTNGXA01.phx.gbl...
>> Hi Ben,
>> Would you please explain the "compatible" means in detail? Based on my
>> knowledge, x64 edition is totally the same sa 32bit edition except more
>> powerful performance.
>> Check following article:
>> Features Supported by the Editions of SQL Server 2005
>> http://msdn2.microsoft.com/en-us/library/ms143761.aspx
>> Let me know if you still have any concerns.
>> Thanks.
>>
>> Best regards,
>> Vincent Xu
>> Microsoft Online Partner Support
>> ======================================================>> Get Secure! - www.microsoft.com/security
>> ======================================================>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others
>> may learn and benefit from this issue.
>> ======================================================>> This posting is provided "AS IS" with no warranties,and confers no
rights.
>> ======================================================>>
>> --
>>From: "Ben Mullen" <bmullengb@.nospam.nospam>
>>Subject: Capatibility between 32 bit and 64 bit SQL Server 2000
>>Date: Wed, 20 Sep 2006 17:47:53 -0500
>>Lines: 7
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
>>X-RFC2646: Format=Flowed; Original
>>Message-ID: <uiw#SbQ3GHA.4228@.TK2MSFTNGP06.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: 198.150.66.2
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP06.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:445761
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Is SQL Server 2000 64-bit edition 100% compatible with SQL Server 2000
>>32-bit edition? I don't believe there would be any problems with us
>> moving
>>to the 64-bit version, but my supervisor is a bit nervous because a
>> previous
>>upgrade of our Dispatch software through a fit when we upgraded to a
new
>>version.
>>
>>
>>