How to copy the tables, schema and views from one SQL Server to another?

There are multiple ways to do this.

1. "Detach Database" from one server and "Attach Database" to another server.


2. Manually script all the objects using SSMS and run the script on new server.


3. Use Wizard of SSMS.