You can also connect to Azure SQL Database using PowerShell. using the information mentioned in this article below.
Powershell Connect To Azure SQL Database
Below are the prerequisites that you must have before proceeding.
- To connect to Azure SQL DB using PowerShell, as a prerequisite, you must install the Azure PowerShell module.
- Now, you need to authenticate to Azure using the Azure PowerShell cmdlet. Once you run the below PowerShell cmdlet, it will prompt you to enter your Azure Credential.
PS C:\WINDOWS\system32> Connect-AzAccount- Next, you can use the Azure PowerShell cmdlet below to verify everything works fine.
Get-AzSqlServer -ResourceGroupName <Your Resource Group>Get-AzSqlServer -ResourceGroupName Demo123If you run the above PowerShell cmdlet and all is ok, you should get the output like the one below. Check out the screenshot below.
ResourceGroupName : Demo123
ServerName : test45
Location : eastus
SqlAdministratorLogin : rajkishore
SqlAdministratorPassword :
ServerVersion : 12.0
Tags : {}
Identity :
FullyQualifiedDomainName : test45.database.windows.net
ResourceId : /subscriptions/1cdf4300-dee5-4518-9c9c-feaa72a5cbd1/resourc
eGroups/Demo123/providers/Microsoft.Sql/servers/test45
MinimalTlsVersion :
PublicNetworkAccess : Enabled- You can run the below script to import the Azure SQL module and set different parameters like database, username, credentials, and query. You can run
Invoke-SqlCmdto initiate the transact SQL query.
Import-Module Az.Sql -Force
$MyParams = @{
'ServerInstance' = 'demo126.database.windows.net';
'Database' = 'demo';
'Username' = 'Rajkishore';
'Password' = 'Raj@12345';
'Query' = 'Your select query;'
}
Invoke-Sqlcmd @MyParams- Now, if you want, you can also read the Azure SQL server and DB, and then you can pass the information to the actual query, as shown below
Import-Module Az.Sql -Force
$resourcegrpName = '<Your Resource Group Name>'
$myServerDetails = Get-AzSqlServer -ResourceGroupName $resourcegrpName
$mysqlDB = Get-AzSqlDatabase -ServerName $myServerDetails.ServerName -ResourceGroupName $resourcegrpName
$MyParams = @{
'ServerInstance' = $myServerDetails.FullyQualifiedDomainName;
'Database' = $mysqlDB.DatabaseName[0];
'Username' = $myServerDetails.SqlAdministratorLogin;
'Password' = ‘<Password>’;
'Query' = 'Your SQL Query;'
}
Invoke-Sqlcmd @MyParamsYou may also like following the articles below
Conclusion
This article discussed the quick steps to connect to Azure SQL Database using PowerShell. Thanks for reading this article!!!
I am Rajkishore, and I am a Microsoft Certified IT Consultant. I have over 14 years of experience in Microsoft Azure and AWS, with good experience in Azure Functions, Storage, Virtual Machines, Logic Apps, PowerShell Commands, CLI Commands, Machine Learning, AI, Azure Cognitive Services, DevOps, etc. Not only that, I do have good real-time experience in designing and developing cloud-native data integrations on Azure or AWS, etc. I hope you will learn from these practical Azure tutorials. Read more.
