Chapter 21. Moving, migrating, and upgrading databases
The more you work with SQL Server, the more likely you are to need to move, migrate, or upgrade a database from time to time, and in this chapter I’ll show you some of the main techniques for doing so. I’ll be focusing strictly on moving (or upgrading, or whatever) an entire database, completely intact, without making changes. You might need to do that if you’re relocating a database to a new SQL Server instance, for example, or if you’re upgrading versions of SQL Server.
I won’t be covering situations where you need to modify the database in some fashion, such as when you’re upgrading the version of the application that uses the database. That’s beyond SQL Server itself.
21.1. Refresh: ...
Get Learn SQL Server Administration in a Month of Lunches now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
