Clone another set Database

There are 2 method to clone another set Database in SQL Server :

1. Back up and Restore ( Local )

• Back up - Tasks (Backup) >  (Destination) Add , choose file or write file (.bak)
• Restore - Tasks(Restore Database ) >  Device : Add File 

     2.  Script ( Server )

• Tasks > generate script 
•  better dont those db , choose table , no user
•  Set Scripting Option - advanced (schema & data) , index - true

if database is so big , and just want few tables have data.

Import Data, choose source 1st, choose destination 2nd, choose table. It will create tables as well.
Run "Script", already generated will be ignore.

Detail Info

http://www.dispatchertimer.com/sql-server/how-to-generate-scripts-automatically-in-sql-server/#_Toc375325158