title: How to copy connection security firewall rules,SSL,TLS from one azure DB for mysql to another azure DB for my sql server using powershell
body: <p>I have restored Azure Database for MySQL single server using powershell script below.<br />
  Now, post restore the DB I had to copy all the firewall rules and other settings from connection security of Azure Database for MySQL single server manually.</p>
  <p>After restore the DB I would like to automate copying the connection security configuration from source (Azure Database for MySQL single server) to the restored (Azure Database for MySQL single server) using powershell script. I couldn't able to figure it out how to automate this.</p>
  <blockquote>
  <p>####################### Restore DB Server ####################### Write-Host &quot;Restoring Azure DB for my SQL Server&quot; $restorePointInTime
  = (Get-Date).AddMinutes(-5) $DBServerbackupStatus=Get-AzMySqlServer -Name $SourceDBServerName -ResourceGroupName $ResourceGroupName | Restore-AzMySqlServer -Name $TargetDBServerName -ResourceGroupName
  $ResourceGroupName -RestorePointInTime $restorePointInTime
  -UsePointInTimeRestore start-sleep -s 60 Write-Host -NoNewline &quot;DBServer Restore process is completed,please find the current status
  below&quot; $DBServerbackupStatus</p>
  </blockquote>