| Author |
Topic |
|
fidke
Starting Member
4 Posts |
 Posted - 2010-07-09 : 11:29:51
|
| We're about to launch a web app backed by SQL server. We have a license for 2000 enterprise. Should we stick with 2000 enterprise or should we start with 2008 express then upgrade to 2008 web edition (or some other edition?) when we hit the 1g ram and 1 processor limit?Thank you experts for your insight .... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
fidke
Starting Member
4 Posts |
Posted - 2010-07-09 : 12:09:04
|
| I looked at this page:https://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspxBut I'm not sure how 2000 enterprise stacks up vs any of those.One thing I would like to use that doesn't seem to be available in the express version is indexed views. Other than that, all the other features all look nice and I'd love to have them if money weren't an issue. But realistically, I'm not sure if we need any of them.Sorry, I should have provided a little more background info .... the app will be a wholesale ecommerce site that's linked directly to our inventory control software. The inventory control software itself is backed by SQL server 2000 enterprise. We're going to migrate the inventory control software to a new server (2003 server) so I was wondering if we should plan on moving to 2008. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
fidke
Starting Member
4 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
fidke
Starting Member
4 Posts |
Posted - 2010-07-09 : 15:11:48
|
| We're running Windows 2003 Server as the OS. We already bought the license and since we're a start up, we won't be able to upgrade to 2008 for a while. Does the OS we're running affect our decision on whether to go with SQL Server 2000 enterprise vs 2008 express? I hadn't even thought of that, but if there's issues then it's definitely something we should consider when choosing which database to go with.Thanks for the info so far! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
SQL Server 2000 Enterprise vs 2008 R2 Express