AzureRM-AutomationSQLDatabase

1.0

The script intends to demonstrate the autonomous creation of a shared infrastructure, development, and production environment for using Microsoft Azure SQL Databases where each environment has it’s own resources. With the use of Microsoft Azure PowerShell allows you to automatically create all the features and services required automatically for each environment.
The
The script intends to demonstrate the autonomous creation of a shared infrastructure, development, and production environment for using Microsoft Azure SQL Databases where each environment has it’s own resources. With the use of Microsoft Azure PowerShell allows you to automatically create all the features and services required automatically for each environment.
The script also shows that the automation process will automatically create in all available regions in your subscription an Azure SQL Database with free tier. There may be regions that your subscription does not allows you to create the Azure SQL Database service.

Script will create:
- A Resource Group for each environment (Shared Infrastructure, Development and Production)
- A Storage Account for each environment.
- One Virtual Network and subnet in Shared Infrastructure environment.
- An Azure SQL server for development and production environment.
- Create a SQL database using free tier in the development environment.
- Create a SQL database using basic tierin the production environment through user defined bacpac.
- Create a SQL Server and database using free tier in all possible subscription regions.


Show more

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Script -Name AzureRM-AutomationSQLDatabase

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Copyright

Ricardo Ramos Cabral

Package Details

Author(s)

  • Ricardo Cabral

Tags

Azure SQL Database PowerShell Automation

Dependencies

This script has no dependencies.

FileList

Version History

Version Downloads Last updated
1.0 (current version) 327 3/11/2017