November 30, 2007 at 11:34 pm
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)
November 30, 2007 at 11:45 pm
Go for sql enterprise edition to have all advantages of sql 2005.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
November 30, 2007 at 11:51 pm
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 ?
December 1, 2007 at 12:01 am
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
December 1, 2007 at 12:07 am
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(
December 1, 2007 at 1:29 am
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.
December 1, 2007 at 1:35 am
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 ?
December 3, 2007 at 4:46 pm
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:
December 4, 2007 at 4:35 am
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
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply