Getting Started — Data Studio
Getting Started
Double-click DBLenseDataStudio.exe — no installation, no prerequisites. The application opens with four tabs representing its four operating modes:
| Tab | Purpose |
|---|---|
| ⬆ BACKUP | Parallel multi-threaded database export with snapshot consistency and GZip compression |
| ⬇ RESTORE | Parallel multi-threaded database restore with drop/recreate, identity insert, and constraint management |
| ⇄ MIGRATE | Streaming producer-consumer pipeline for server-to-server migration (export and import run concurrently) |
| 📦 EXPORT / IMPORT | Cross-RDBMS data transfer and multi-format file export/import with automatic column mapping |
Connecting to a Server
Click the Connect button on any tab to open the connection dialog. Data Studio supports four authentication modes:
| Mode | Description | Use Case |
|---|---|---|
| Windows Authentication | Uses your current Windows domain credentials | On-premises Active Directory environments |
| SQL Server Authentication | Username and password stored in SQL Server | Mixed-mode servers, cross-domain access |
| Azure Entra ID (Password) | Azure AD username + password | Azure SQL MI with non-MFA accounts |
| Azure Entra ID (MFA) | Interactive Azure AD with multi-factor | Azure SQL MI with MFA enabled |
Connection settings are remembered between sessions. Passwords are encrypted using DPAPI (Windows Data Protection).