SQL 2005 limitations ?

Question

Post reply

SQL 2005 limitations ?

dr_csharp

SSCommitted

Points: 1765
More actions
November 30, 2007 at 11:34 pm

#181834

hello my friends . i want to move my SQL dataBase from 2000 to 2005 but i need a uniqe edition for all my Application users.i mean an edition with no limitation about windows version ( XP , 2003 , .. ) and the main SQL capabilities..
thanks :O)

Viewing 9 posts - 1 through 8 (of 8 total)

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

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 1

Go for sql enterprise edition to have all advantages of sql 2005.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

dr_csharp SSCommitted Points: 1765 More actions · Answer 2

Sugesh Kumar (11/30/2007)
Go for sql enterprise edition to have all advantages of sql 2005.

dear friends ! we cant setup enterprise edition on XP os ! hum ?

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 3

Why do you use XP as your windows server. Xp lacks many features as a server side OS. My recommendation is use windows 2003 server to have many features and Xp for client side.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

dr_csharp SSCommitted Points: 1765 More actions · Answer 4

Sugesh Kumar (12/1/2007)
Why do you use XP as your windows server. Xp lacks many features as a server side OS. My recommendation is use windows 2003 server to have many features and Xp for client side.

its enough for us to use XP and we dont use any spesific feature of Client-Server that has not support in XP.now our Application just run on XP besides whereas most of my Application users use XP we should use XP :O(

Ian Yates SSCoach Points: 19738 More actions · Answer 5

Frankly, if you are going to have a couple of users on a workgroup-based network then you'll survive with SQL Express.

There are only editions of SQL Server than run on Windows XP - Express & Developer. You cannot run Developer in a production environment so you're stuck with Express.

Having said that, the cost of Windows 2003 Small Business Server is practically free when you buy it with hardware. Then you'll have network management (and SBS is a doddle to set up) and you can then run Express on the Standard edition of SBS or get the Premium edition of SBS and get SQL Workgroup...

Which features of SQL 2005 are you going to use. I think that if you're willing to run on XP as a server then you certainly won't even have thought of the features that only Standard or Enterprise have, so Workgroup or the free Express edition ought to do nicely for you.

dr_csharp SSCommitted Points: 1765 More actions · Answer 6

Ian Yates (12/1/2007)
Frankly, if you are going to have a couple of users on a workgroup-based network then you'll survive with SQL Express.
There are only editions of SQL Server than run on Windows XP - Express & Developer. You cannot run Developer in a production environment so you're stuck with Express.
Having said that, the cost of Windows 2003 Small Business Server is practically free when you buy it with hardware. Then you'll have network management (and SBS is a doddle to set up) and you can then run Express on the Standard edition of SBS or get the Premium edition of SBS and get SQL Workgroup...
Which features of SQL 2005 are you going to use. I think that if you're willing to run on XP as a server then you certainly won't even have thought of the features that only Standard or Enterprise have, so Workgroup or the free Express edition ought to do nicely for you.

is there any limitation about workgroup edition ?

matt stockham SSCrazy Eights Points: 9942 More actions · Answer 7

Standard edition and below will work on XP - so that will provide the most functionality if you are only concerned with XP, 2000, 2003, Vista. You then need to look at which features you need, there are several sites that give this information and here is one:

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

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 8

I hate to break it to you, dr_csharp, but all SQL Server 2005 have some limitations on what OS they will use. At minimum, any Windows 2000 OS has to have SP4 installed. Any XP or 2003 OS has to have SP1 installed. And you can't use any SQL Server 2005 on an OS earlier than these editions.

Follow this link to find out what hardware & OS limitations each version of SQL 2k5 has. You'll have to go about halfway down to find the OS listing: http://msdn2.microsoft.com/en-us/library/ms143506.aspx

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.