Azure SQL Database

Azure SQL Database, Microsoft's cloud-based relational database service, provides organizations with a scalable and fully managed solution for storing, querying, and managing structured data in the cloud. Offering seamless integration with Azure services, comprehensive T-SQL support, and automatic backups, Azure SQL Database is designed to meet the demands of modern applications, enabling developers and administrators to focus on building and optimizing their systems without the overhead of infrastructure management.

Server

The URL of the database server, as exposed by Azure.

Authentication

• ‍SQL Server Connect securely through a Windows user account for authenticated access to SQL Server resources.

• ‍AAD Managed Identity ‍Connect to resources using Azure Active Directory (AAD) Managed Identity or by specifying a user identity for authentication.

• ‍‍AAD Password ‍Authenticate through an Azure Active Directory (AAD) user name and password.

• ‍‍AD Integrated ‍Establish a connection through a federated Windows user account.

• ‍‍AAD Interactive ‍Connect via an interactive authentication flow, using multi-factor authentication for heightened security and user-friendly authentication.

Database name

Click on Select to pick a database from the list of all databases available on the server, or type in by hand.

Include views as tables

If checked, this will list all of the database views as if they were tables in the project and allow for data copying from said views and create the tables on the target.