Huh? Detach/attach and backup/restore both leave the DB in the compat mode that it was when backed up/detached.

This was part of the answer as a reply to my initial comment:...

The Detach/Attach operation might be doable going across different versions from operation standpoint, but it is very important to have compatibility modes in sync from the perspective of database...

Detach/Attach can only be done with databases in the same SQL Server compatibility mode - meaning you can only for example Detach/Attach a 2016 database in the SQL server 2016...

Ok, we're on the same page now.

Thanks!

That helps!

Issues related to consistency checks and synchronization are addressed prior to the database being imported using SQL Server 2016 Upgrade Adviser in a typical upgrade scenario. When restoring...

From your answer I take it to mean that there is no straight process for upgrading from SQL Server 2005, because Microsoft does not have a built-in mechanism for an...

Is there direct upgrade path from SQL server 2008 to SQL Server 2016? What about earlier versions?

Managing a production database environment is a delicate, sensitive, and vexing at times. I sympathize with you on the upgrade issue you had and which you so well described as...

I am not able to locate the TargetServersRole role in the msdb database. is this role user defined?

Please advise. Thanks.

Thanks for the first part. What other this I need to do to allow user to job history and the alike..

Erico