Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
This question already has an answer here:
Is there any check list for how to do migration from SQL Server 2008 to SQL server 2016 ?
I am building a new server for the 2016 want to move all the DBs from the old server 2008 to the 2016
any suggestions ?
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
Before you migrate any databases, run 'Assesment' in Data Migration Assistant. It'll point compatibility issues between versions and also show you some best-practice suggestions. Then proceed with actual migration. I noticed that one thing that DMA doesn't do, is to raise a warning if a database is running in Sql Server 2005 (or earlier) compatibility mode. Sql 2016 does only support compatibility modes 2008 or higher. So don't trust it blindly as there may be more aspects it ignores.
