I exported my azure SQL Managed instance to a Bacpac file using SQLPackage, Now I want to store it on a azure file storage. Before I want to copy the bacpac to the file storage, I want to encrypt it using a Secret from Azure key vault. SQLPackage does not have any encryption functionality, does anyone know a good tool I can use to encrypt the bacpac file before copying to the file storage? Preferably a tool I can call in my ps1 (powershell) script. I want to use the same tool to decrypt the bacpac file again once downloaded from the file storage.
Asked
Active
Viewed 159 times
1 Answers
0
The official approach is to use client-side encryption. However, there is no existing tools. You may write a program to upload the encrypted content and download the decrypted content.
Here are two official client=side encryption samples:

Jack Jia
- 5,268
- 1
- 12
- 14