What''s the difference between SQL 2005 and SQL 2005 Extended?

Question

Post reply

What''s the difference between SQL 2005 and SQL 2005 Extended?

Rod at work

SSC-Dedicated

Points: 34008
More actions
September 5, 2007 at 7:43 am

#197691

I've got an MSDN subscription, and I also have a new 64-bit PC with the 64-bit version of Vista installed on it. I want to put on SQL Server 2005 Developer Edition, so I've gotten out my MSDN DVD and noticed that it has SQL Server 2005 Developer Edition and SQL Server 2005 Developer Edition 64-bit Extended.
What is the difference between the two?

Kindest Regards, Rod Connect with me on LinkedIn.

Viewing 5 posts - 1 through 4 (of 4 total)

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

from some page on microsoft:

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

Extended System Support

SQL Server 2005 64-bit versions include support for extended systems, also known as Windows on Windows (WOW64). WOW64 is a feature of 64-bit editions of Microsoft Windows that allows 32-bit applications to execute natively in 32-bit mode. Applications function in 32-bit mode even though the underlying operating system is running on the 64-bit platform.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Rod at work SSC-Dedicated Points: 34008 More actions · Answer 2

Thank you, Lowell, for your response and letting me know what the Extended System Support was all about.

I guess now is the right time to ask, which would people recommend that I install (the 32-bit version of the 64-bit version)? As I said I only want to install the Developer Edition. I'll be putting it into a duel-core AMD 64 Athlon, running at 2.8 GHz with 2 GB of RAM.

Kindest Regards, Rod Connect with me on LinkedIn.

Rod at work SSC-Dedicated Points: 34008 More actions · Answer 3

Something else I should have mentioned is that I have some test databases that I use, currently on another Vista system that is 32-bit. I would want to move those databases to this new machine. Would there be a problem, if I attempted to move those 32-bit versions of those SQL databases onto a 64-bit version of Windows Vista, if SQL on that machine is also 64-bit?

Kindest Regards, Rod Connect with me on LinkedIn.

Lowell SSC Guru Points: 323518 More actions · Answer 4

won't make any difference as far as databases go.... they are backed up to a specific format for SQL 2005,a dn in a manner backwards compatible with non-service pack-ed 2005 installations; the difference you would see is in performance.... 64 bit should operate quicker, with all other things being equal.

The same situation is when you detatch and reattach the mdf's....no issues. you can't restore them on prior versions of course, like 2000 or sql7, but you can restore or attach previous version on 2005, and they will get upgraded to teh new format.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!