Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    95

    Unanswered: 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, Dave

  2. #2
    Join Date
    May 2002
    Posts
    299
    There would be no side-effect for going from std to ent at all.
    --
    -oj
    http://www.rac4sql.net

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    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).

  4. #4
    Join Date
    Apr 2004
    Location
    Melbourne
    Posts
    144
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •