You can copy objects from one database to another database,
and optionally copy the data that is stored in the objects that you
copy.
Overview of copying database objects
You can copy database objects from one database to another
database or from one schema to another schema within the same database.
Copying database objects between and within databases
In the Data Source Explorer, you can copy database objects
and, optionally, the object data from one database to another database,
or within a database from one schema to another.