Overview
Azure SQL is a cloud-based relational database management system (RDBMS) that provides a range of features and capabilities to help you build and run your applications. With Azure SQL, you can easily scale your database resources up or down as your needs change, and you can also easily manage and monitor your database performance.
Supported Authentiction Methods
DBCode supports the following authentication methods for Azure SQL:
- SQL Based Username and password
- Microsoft Entra ID
- Windows Integrated Authentication
Connect Single Database
To connect to a single Azure SQL database, follow these general steps:
- Open the DBCode Extension: Launch Visual Studio Code and open the DBCode extension.
- Add a New Connection: Click on the “Add Connection” icon.
- Complete new connection form: Choose Azure SQL as the type, and enter the required information.
- Connect: Click save to connect to your Azure SQL database.
- Start Managing Your Databases: Once connected, you can start managing your databases directly from Visual Studio Code.
For detailed instructions on connecting to Azure SQL, refer to the Connect article.
Connect Multiple Databases
To connect to Azure SQL as a cloud provider and access multiple databases, follow these general steps:
- Open the DBCode Extension: Launch Visual Studio Code and open the DBCode extension.
- Add a New Connection: Click on the “Add Connection” icon.
- Select Your Provider: Choose the Azure cloud provider from the list on the right.
- Authenticate: Follow the authentication process specific to the provider.
- Start Managing Your Databases: Once connected, you can start managing your databases directly from Visual Studio Code.
For detailed instructions on connecting to Azure SQL, refer to the Connect a Cloud Provider article.
By using Azure SQL with DBCode, you can connect to your Azure SQL databases, query and manage your data, and visualize your results, all directly from Visual Studio Code.
For more information about Azure SQL, check out Azure SQL.