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







See Also:



No comments: