January 31, 2022 at 2:06 pm
Hi All,
Continuation of this post https://www.sqlservercentral.com/forums/topic/upgrade-sql-and-os-of-legacy
Would like to know, SQL 2000 supported OS versions? and for SQL 2005 as well.
So that, I can build 2 test VMs so that we can move - SQL 2000 to 2005, 2005 to 2008R2 then finally to SQL 2014.
January 31, 2022 at 3:01 pm
Something to note - installing an unsupported application (SQL 2000) on an unsupported OS (any that would support SQL 2000) will result in an unsupported scenario.
That being said, a quick google for SQL 2000 brought me to this website:
https://www.microsoft.com/en-us/download/details.aspx?id=51958
Which states:
Supported Operating System
Windows 2000, Windows 98, Windows ME, Windows NT, Windows XP
Windows Server 2003, Standard Edition 1 Standard Edition Windows Server 2003, Enterprise Edition 1 Windows Server 2003, Datacenter Edition 1 Windows 2000 Server Windows 2000 Advanced Server Windows 2000 Datacenter Server Microsoft Windows NT Server version 4.0 with Service Pack 5 (SP5) or later Windows NT Server version 4.0, Enterprise Edition, with SP5 or later
Now, for SQL 2005, a quick google brought me here:
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms143506(v=sql.90)?redirectedfrom=MSDN
Where if you scroll down, it has a list of supported OS's.
Now, what I would recommend is that you start with whatever OS you currently have SQL 2000 running on and then work to upgrade to Windows 2000 with the latest SP as that is supported by both SQL 2000 and 2005. Then upgrade to SQL 2005, then move that to a new physical server with a newer OS, then upgrade to 2008R2, then to 2014. I would HIGHLY recommend you go to 2017 or 2019 at a MINIMUM though as 2014 has passed end of mainstream support and extended support is only 2 years away. 2017 hits end of mainstream support this year, so 2019 is probably a safer bet.
Basically, I am recommending that if you are spending the time and effort to upgrade, might as well upgrade to a fully supported version.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
January 31, 2022 at 3:40 pm
Thank you Brian for the note.
I have some idea now to prepare documentation.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply