Microsoft Azure - Creating a database copy to same or different server

We can take a copy of database in 3 ways:

1) using copy option in Azure portal
2) using T-SQL
3) using powershell command

Method1: Using copy option in Azure portal

SQL DATABASES -> DATABASES  -> in the bottom we can find a Copy option as shown in below image:

 

Method2: Using T-SQL

CREATE DATABASE Copy2_MyDBonCloud
AS COPY OF MyDBonCloud
GO

Method3: Using powershell command

• Create a copy of an Azure SQL database using PowerShell

• DMV - sys.dm_database_copies - Returns information about the database copy.

See Also:

• My Other posts on Microsoft Azure SQL Server
• https://azure.microsoft.com/en-us/documentation/articles/sql-database-copy/