We're planning a move from SQL 2005 to SQL 2017. We're using new servers, standard edition. We plan to Backup/Restore databases to make the move. We've run the Data Migration Assessment tool from Microsoft. No 'Breaking' functionality was identified.
I see some posts about moving between other versions but not '05 to '16 or '17.
Is there any significant difference to only moving to Sql 2016? If we're moving doesn't it make sense to go ahead to Sql 2017?
Can you provide any pointers, suggestions or warnings? Very much appreciated.