locked
SQL Server 2000 Enterprise Edition Compatability with Latest Operating Systems RRS feed

  • Question

  • Hi Team,

    My client is using SQL Server 2000 Enterprise edition for the database in the Production.

    Now,We are planning to load that data from SQL 2000 to SQL 2012 and test the functionality.

    Can you please tell me on which operations systems the SQL Server 2000 is compatible to Install ?

    like Windows Server 2012/ 2012 R2/ Windows 7/ 8 etc.

    Thanks

    Srikrishna

    Friday, May 1, 2015 8:58 AM

Answers

  • Installing SQL Server 2000 on Windows 2008 or later is not supported, but your question is about compatibility rather than support.  SQL Server 2000 may work with the database engine but not with some other features and you'll probably need to click through warnings installation. Proceed at your own risk if you want to go down that path.

    I suggest you install on Windows 2003 for your migration testing to avoid obstacles.  Not that support ends for Windows Server 2003 in a few months.


    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    • Proposed as answer by Charlie Liao Monday, May 4, 2015 2:23 AM
    • Marked as answer by Charlie Liao Monday, May 18, 2015 8:44 AM
    Friday, May 1, 2015 11:38 AM

All replies

  • You will be not able to migrate from SQL 2000 to 2012 directly. Migration from 2000 to 2012 requires an intermediate step.

    here more tips

    http://blogs.technet.com/b/mdegre/archive/2012/06/15/migration-sql-server-2000-to-sql-server-2012.aspx


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    Friday, May 1, 2015 10:19 AM
  • SQL Server 2000 is not 100% compatible with Windows Serve 2008 or greater as you will not have all of the available Counters due to the different bit versions.

    Furthermore SQL Server 2000 is no longer supported.

    I Strongly suggest you migrate your databases to SQL Server 2008 or greater; if you want to migrate to 2012 or Greater you will need to migrate to 2008n first and then upgrade your databases.


    Please click "Mark As Answer" if my post helped. Tony C.

    Friday, May 1, 2015 10:25 AM
  • Friday, May 1, 2015 11:32 AM
  • Installing SQL Server 2000 on Windows 2008 or later is not supported, but your question is about compatibility rather than support.  SQL Server 2000 may work with the database engine but not with some other features and you'll probably need to click through warnings installation. Proceed at your own risk if you want to go down that path.

    I suggest you install on Windows 2003 for your migration testing to avoid obstacles.  Not that support ends for Windows Server 2003 in a few months.


    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    • Proposed as answer by Charlie Liao Monday, May 4, 2015 2:23 AM
    • Marked as answer by Charlie Liao Monday, May 18, 2015 8:44 AM
    Friday, May 1, 2015 11:38 AM