SQLTeam.com | Weblogs | Forums

Sql Server Upgrade from Sql 2000

Hello,
We are planning to upgrade our Sql server 2000 and wondering which latest edition i can upgrade it?
It will be a side by side upgrade. I know that i have to upgrade first 2008R2 then next edition but little confused as It's only support from 2008R2 to Sql 2014/2016 or i can upgrade it to Sql 2017?

Ex. Sql 2000 ==> Sql 2008R2 ==> which edition latest?
Is it better i should go Sql 2000 ==> Sql 2005 ==> which edition latest?

We are finally planning to upgrade our Sql server 2000 and wondering which latest edition i can upgrade it?
It will be a side by side upgrade. I know that i have to upgrade first 2008R2 then next edition but little confused as It's only support from 2008R2 to Sql 2014/2016 or 2005 to Sql 2014/2016 or i can upgrade it to Sql 2017?

Ex. Sql 2000 ==> Sql 2008R2 ==> 2017 ==>>>>>>>>> i can go this route?
Is it better i should go Sql 2000 ==> Sql 2005 ==> Sql 2017 I can go this route?

Thanks

go to 2008R2 and then to 2017
2005 to 2017 is not supported.

Thanks Javeed.