Azure SQL Database Restore - geeklearningio/gl-vsts-tasks-azure GitHub Wiki

Icon

With this task, you can restore an Azure SQL Database to another Azure SQL Database on the same server using the latest point-in-time backup.

Requirements

You should have Setup an Azure Resource Manager Endpoint to use this task.

Add the task to your Build or Release Definition

Add-Tasks

You will find the task in the "Deploy" category.

Configuration

Configure-RestoreSqlDatabaseToSqlDatabase

General

  • Azure RM Subscription - Specifies the Azure Resource Manager Service Endpoint to use.
  • Azure SQL Server Name - Azure SQL Server name like, FabrikamSQL.database.windows.net,1433 or FabrikamSQL.database.windows.net.
  • Source Database Name - Name of the source Azure SQL Database from which to restore.
  • Target Database Name - Name of the target Azure SQL Database. If exists, will be deleted prior to restore!