SQL Server 2005 64 bit under Windows7

#1

I am migrating a database I have been developing in SQL Server 2005 from a XP
SP3 machine to a Win 7 machine. I am wondering if I should be installing the
64 bit version in Win 7 or stay with the 32 bit version for continuity?

#2

Harp Cyclone (Harp Cyclone (AT) discussions (DOT) microsoft.com) writes:

Quote:

I am migrating a database I have been developing in SQL Server 2005 from
a XP SP3 machine to a Win 7 machine. I am wondering if I should be
installing the 64 bit version in Win 7 or stay with the 32 bit version
for continuity?

I see little reason not to use x64 for the OS.

For SQL Server, you need to make sure that you don't use any extended
stored procedures, or use linked servers for which there are no 64-bit
providers. But if there are no such problems go for 64-bit SQL Server.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Server 2005 64 bit under Windows7

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup

SQL Server 2005 64 bit under Windows7 - 11-01-2009 , 11:32 AM

Re: SQL Server 2005 64 bit under Windows7 - 11-01-2009 , 12:34 PM