Monday, March 19, 2012

Mixed environments - SQL 2000 Standard & Enterprise?

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, DaveThere would be no side-effect for going from std to ent at all.|||The only problem I can forsee would be if you use a feature that only exists in Enterprise Edition. Most of the ones I can think of off the top of my head do not affect code, though (clustering, log shipping).|||I would use the SQL Server Dev Edition for the test environment since it has the full functionality as SQL Server Ent like log shipping.

No comments:

Post a Comment