Azure SQL Database Management - Create or update a database

Important: This connector and its actions have been removed from Nintex Workflow and can now be found in Nintex Gallery.

Use the Azure SQL Database Management - Create or update a database action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to create a new database or update the properties of an existing one.

For more information about the Azure SQL Database Management connector, go to Azure SQL Database Management.

Before you begin: 

Jump to:

Configure the Azure SQL Database Management - Create or update a database action

  1. Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.

  2. Select a Connection. If you do not have a connection, see Add a connection.

  1. Select Subscription credentials which uniquely identify a Microsoft Azure subscription.

  2. Select a Resource group name of the resource group that contains the resource.
  3. Select a Server name.
  4. Specify a Database name.
  5. Select a Azure Location where the database should be created.
  6. Specify a SKU name.

Azure SQL Database Management - Create or update a database action fields and settings

Section

Field

Description

Variable types

(Unlabeled)

Connection Credentials and other settings that enables workflows to communicate with external systems, services, or applications. It's required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.

The Azure SQL Database Management connection to use to create or update the database.

To refresh the available connections, click .

(n/a)
Subscription Subscription credentials which uniquely identify Microsoft Azure subscription. Text, Decimal, Integer, Boolean, DateTime, Collection
  Resource group name The name of the resource group that contains the resource. You can obtain this value from the drop-down or get it from your Azure portal. Text, Decimal, Integer, Boolean, DateTime, Collection
  Server name The name of the server. Text, Decimal, Integer, Boolean, DateTime, Collection
  Database name The name of the database. Text, Decimal, Integer, Boolean, DateTime, Collection
  Location The supported Azure location where the database should be created. Text, Decimal, Integer, Boolean, DateTime, Collection
SKU Name The name of the SKU, typically, a letter + Number code, e.g. P3. Get your SKU Name from your Azure portal. Text, Decimal, Integer, Boolean, DateTime, Collection
  Tier The tier or edition of the particular SKU, e.g. Basic, Premium. Text, Decimal, Integer, Boolean, DateTime, Collection
  Capacity The capacity of the particular SKU. Integer
Properties Database size The maximum size of the database expressed in bytes. Integer
  Backup storage redundancy The storage account type to be used to store backups for this database, either Geo, Local, or Zone. Text, Decimal, Integer, Boolean, DateTime, Collection
  Sample Database The name of the sample schema to apply when creating this database. Text, Decimal, Integer, Boolean, DateTime, Collection