Restoring individual databases on SQL server 2008 to SQL Server 2017

Zack
Zack used Ask the Experts™
on
Hi EE,

We have several databases of various compatibility levels on SQL server 2008 we want to trial on SQL server 2017.
Other than setting up a  sandpit environment of SQL server 2008 and upgrading the databases to SQL server 2017 is anything we can to restore these individual databases to SQL server 2017.  

Any suggestions are appreciated I am willing to look at tools as well.

Thank you
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
Since SQL Server offers backward compatibility, you will be able to restore your SQL Server 2008 databases in SQL Server 2017 without any issues but I would suggest you to run this Database Migration Assistant to identify whether you have any features in SQL Server 2008 that are deprecated in SQL Server 2017 and might not work..

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/prepare-for-upgrade-by-running-data-migration-assistant?view=sql-server-2017
ZackGeneral IT Goto Guy

Author

Commented:
Cheers for the info.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Thanks..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial