PSDB

PSDB module allows you to ease the automation of Azure Sql import and export. Also, it allows you to connect to the database and run queries.

It comes with tab completion of resource groups, sql servers, storage accounts and key vaults to select the resources easily. Functions Get-PSDBDatabaseData and Invoke-PSDBDatabaseQuery allows you to open database connection and perfom database operations.

View the introduction and module usage here.

Getting Started

You can directly install the module from PowerShell gallery.

Release Notes

• Change Log

Dependencies

• Az.Accounts
• Az.Sql
• Az.Resources
• Az.Storage
• Az.KeyVault

Functions

• Export-PSDBSqlDatabase
• Get-PSDBConnectionString
• Get-PSDBDatabaseData
• Get-PSDBImportExportStatus
• Get-PSDBKVSecret
• Import-PSDBSqlDatabase
• Invoke-PSDBDatabaseQuery
• New-PSDBConnectionString
• Set-PSDBDefault

Test Results

Build Locally

Clone the repo and run .\psake.ps1 which installs the dependencies and runs the default task. This indeed updates the functions and classes in .\PSDB folder.

License

This project is licensed under MIT

Contributions

Contributions are welcome, the goal is to make this module more robust and common to use on ease in all possible scenario.