sql-database-copy-portal.md

title	description	services	documentationcenter	author	manager	editor	ms.assetid	ms.service	ms.custom	ms.devlang	ms.date	ms.author	ms.workload	ms.topic	ms.tgt_pltfrm
Copy an Azure SQL database using the Azure portal | Microsoft Docs	Create a copy of an Azure SQL database	sql-database		CarlRabeler	jhubbard		daa6f079-13ed-462f-b346-e201aa61681b	sql-database	migrate and move	NA	02/07/2017	carlrab	data-management	article	NA

Copy an Azure SQL Database using the Azure portal

The following steps show you how to copy a SQL database with the Azure portal to the same server or a different server.

Note

You can also copy a SQL database using PowerShell or Transact-SQL.

To copy a SQL database, you need the following items:

• An Azure subscription. If you need an Azure subscription simply click FREE TRIAL at the top of this page, and then come back to finish this article.
• A SQL database to copy. If you do not have a SQL database, create one following the steps in this article: Create your first Azure SQL Database.

Copy your SQL database

Open the SQL database page for the database you want to copy:

1. Go to the Azure portal.

2. Click More services > SQL databases, and then click the desired database.

3. On the SQL database page, click Copy:

   

4. On the Copy page, a default database name is provided. Type a different name if you want (all databases on a server must have unique names).

5. Select a Target server. The target server is where the database copy is created. You can copy the database to the same server, or a different server. You can create a server or select an existing server from the list.

6. After selecting the Target server, the elastic pool, and Pricing tier options will be enabled. If the server has a pool, you can copy the database into it.

7. Click OK to start the copy process.

   

Monitor the progress of the copy operation

• After starting the copy, click the portal notification for details.

  

  

Verify the database is live on the server

• Click More services > SQL databases and verify the new database is Online.

Resolve logins

To resolve logins after the copy operation completes, see Resolve logins

Next steps

• To learn about managing users and logins when copying a database to a different logical server, see How to manage Azure SQL database security after disaster recovery.
• To export a database to a BACPAC file using the Azure portal, see Export the database to a BACPAC using the Azure portal.
• Business Continuity Overview
• SQL Database documentation