625
Chapter 23: Transferring Databases
23
If you detach a database from a lower level of SQL Server and attach it to a higher level one (for example, 2005
to 2012), the database automatically upgrades. After you attach a database to a higher-level version, you cannot
detach and reattach to a lower level version.For more details on the security roles, refer to Chapter 33, “Authorizing Securables.”Detaching and attaching the database can carry with it any database users, security roles, and
permissions, but it cannot replicate server logins. These need to be resolved manually on the
destination server. It’s best to coordinate security with the network administration folks and
leverage their security groups. If the source and destination servers have access to the same
network security groups, this can alleviate the security login issues for most installations.Using Management Studio, right-click the database to be copied, and select Tasks ➪ Detach.
The Detach Database dialog box, as shown in Figure 23-7, appears.FIGURE 23-7
The Detach Database feature removes the database from SQL Server’s list of databases and
frees the fi les for copying.c23.indd 625c23.indd 625 7/31/2012 9:25:22 AM7/31/2012 9:25:22 AM
http://www.it-ebooks.info