When you right click any Database in the SSMS, you can access the Copy Database tool:

This feature easily allows you to copy or move a database from one server to another or within one server.

But before you can do this you need to ensure the following conditions:

• SQL Server Agent service must be running on the destination server
• SQL Server Integration Services service must be running on the destination server
• These services must be running with an account that has at least sysdbadmin rights on the target sql server.
• The source database must not have an owner that is a local account to the source server (e.g. LocalServer1\Tom),
  otherwise the transfer will fail. If it is associated with a local account, change the owner, for instance to sa.

After the prerequisites are confirmed, you can launch the Copy Database wizard. There are currently two ways to copy or move the database:

1. Use the detach and attach method
2. Use the SQL Management Object Method

Use the SQL Management Object Method

1) is significantly faster but requires a share on the target server and a configured Integration Services Proxy Account on the target server. So the easiest way to copy the source is method 2).

After some view steps in the wizard, you reach the Select Server Objects page where Logins are preselected:

Copying the Logins is not necassarily required unless you have granted some rights to specific logins, so in some cases you can remove the Logins from the Selected related objects list. in some cases.

Use the detach and attach method

If you decide to use this method to copy or move a database, before you can archive this, you need to create a Credential and a Proxy for the SSIS Package Execution in the SQL Server Agent:

To create a credential that will be later associated to the proxy open Server/Security/Credential and right click to open the popup menu where you select New Credential:

The New Credential Dialog is self explanatory so just configure the required values.

Now you can create a  Proxy:

In the dialog select a proxy name of your choice and as Credential name select the previously created credential. Select at least “SQL Server Integration Services Package” and that’s it: