Two way to copy database from one machine to another

1) Can use SQL server's backup function to backup the database to a file and then restore it in your target machine
2) Can right click database and choose Task tab, from there you can see "generate script". Click it to run script generation and then copy the save sql file into your target machine. Open SQL server then run that sql file. Unfortunately this can only copy everything except the data inside.

Comments

Popular Posts