Migrating data to a new database location
This topic describes moving a single node's data to another Microsoft SQL Server database.
If you have a replicated instance and plan on moving data to a different SQL Server version, all nodes must be done simultaneously and to the same version of SQL Server, as replication requires the database versions to be perfectly equal.
Some common use cases for this:
The database is on a dated operating system (OS) and must be migrated to a new OS.
The database itself is outdated, and data needs to be migrated to a more recent SQL Server.