Get tips for updating to Microsoft SQL Server 2014, including using SLQ's Copy Database Wizard and a checklist with key tasks to complete during your migration plan.

The other three methods allow an individual database to be upgraded through migration: 1) Copy Database Wizard 2) Attach/Detach 3) Backup/Restore.

I think the "Copy objects" option in the database copy wizard is the one you really want to use, and I'm pretty sure that it requires an exclusive lock (i.e., no other active connections) on the ...