How to migrate SQL Server databases

Two scenarios of database migration: https://www.cnblogs.com/mcgrady/p/7614491.html

Programme I

1, first package the database files on the source server (including the MDF and LDF files) and copy them to the destination server.

2, unzip, and then attach the database on the target server

Summary: Suitable for large databases (50GB or more), need to quickly migrate data, and mobile hard disk space is large enough.

Back to top scenario two

Restore after backup

1, Backup

Database object Right-click \ task \ Backup

Note that if the database file is large, it is best to select ' Compress backup '

2, restore

Copy the backup file to the destination server, and then restore the database.

Summary: Suitable for small and medium sized databases (otherwise the backup time is longer), is not very urgent, and mobile hard disk space is limited.

How to migrate SQL Server databases