TDM
Dashboard
Jobs
Configuration
Jobs
+ New Job
Saved Jobs
▶ Run a Step
Name
Type
Status
Created
Actions
Loading...
▶
Full Pipeline
Download → Restore → Obfuscate → Backup
Production (.bak)
Database Name
*
Country
*
Blob Pattern
Options
Skip Download
Skip Obfuscate
Individual Steps
1
Download from Blob
Fetch the latest production backup from Azure Blob Storage to the local working directory.
DownloadFromBlob
▶ Run
2
Restore Backup
Restore a .bak file onto the working SQL Server using WITH MOVE to target data directories.
RestoreBackup
▶ Run
3
Obfuscate Database
Apply obfuscation rules and the SQL masking script to a restored database in-place.
ObfuscateDatabase
▶ Run
4
Backup & Archive
Back up the obfuscated database, zip it, and optionally upload to Azure Blob Storage.
BackupAndArchive
▶ Run
Additional Steps
Import Bacpac
Import a .bacpac file into SQL Server using SqlPackage.exe. Useful for schema-only refreshes.
ImportBacpac
▶ Run
Restore from Working Server
Restore a database directly from a backup on the working server without downloading from blob.
RestoreFromWorkingServer
▶ Run
New Job
×
Name
*
Job Type
*
— Select type —
FullPipeline
DownloadFromBlob
RestoreBackup
ObfuscateDatabase
BackupAndArchive
ImportBacpac
RestoreFromWorkingServer
DeployToEnvironment
Configuration (JSON)
*
Enabled
Delete Job
×
Are you sure you want to delete
?
Execution history will be preserved.
Download from Blob
×
Blob Pattern
*
Glob pattern to match blobs in the container (e.g.
*OmegaDB*
).
Destination Path
Leave blank to use the configured working directory.
Resume partial downloads
Restore Backup
×
Database Name
*
Backup File Path
*
Obfuscate Database
×
Database Name
*
Country
Leave blank to use the configured default country.
Backup & Archive
×
Database Name
*
The obfuscated database to back up and zip.
Import Bacpac
×
Database Name
*
Bacpac File Path
*
Restore from Working Server
×
Database Name
*