October 6, 2005 at 4:01 pm
We are upgrading a production database server to new hardware. The server is currently running SQL Server 2000 Standard Edition. We are thinking about installing SQL Server 2000 Enterprise Edition, however that would mean the test server (2000 Standard) and production server (2000 Enterprise) have different edtions of SQL Server. How much of a risk does this present? Later in the year we would upgrade test to SQL Server 2000 EE, but for a couple of months the environments would be different.
Thanks, Dave
October 6, 2005 at 4:06 pm
I would say more or less no risk at all. You might of course get different query plans etc, but I assume your server's are not running the same hardware anyway so that should not matter.
October 7, 2005 at 4:51 am
If you get any problems in Production that are related to EE functionality, you will not be able to test any fixes for these on a SE instance. Also, as Chris says your execution plans may be diffrent, which could result in worse performance for some queries, although most differences should give better performance.
The chances of getting such problems are low, but there is a definite risk in using different SQL and OS versions in Dev, Test, Prod. We try to keep these consistant in our shop.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
October 7, 2005 at 3:00 pm
I have to agree with Ed on this. Nobody ever got fired because they made their test environment just like production. Or at least as close as possible.
Now, you may want to consider upgrading test to EE when you do production. Depending on your licensing agreement with MS, it may not cost anything.
Good luck!
jg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply