'Cannot see Azure DB tables when using Visual Studio
I'm new to Azure and I'm trying to connect to our Azure DB using Visual Studio.
I can connect to the DB fine, but when I expand the DB I cannot see any DB Objects. See the image below. I've Googled the issue but cannot find where anyone has replicated this issue, so I accept I'm likely doing something wrong!
I can query the DB fine and it will return results.
Solution 1:[1]
To connect the visual studio to azure database and view the tables of database in visual studio follow the following steps:
- Open your project in visual studio, Click on server explorer
- Then click on SQL server Object explorer
- Then click on Add SQL Server
- Then expand Azure, click on your mail id and select subscription.
- Then it will show all databases present in your subscription, select your database I will fetch all information expect password, provide your password and click on connect.
It will show all your databases tables from azure database
You can refer to this Document for more information: Work with Visual Studio to connect to SQL Databases in Azure.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | NiharikaMoola-MT |