Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Server Object Explorer in VS2015 Professional not showing Azure database

Microsoft at it again. So my SQL object explorer in Visual Studio stopped working and shows the error in yellow. The mentioned element is a symmetric key that I generated in order to use AES encryption. Now having it is useless for me because I have to open SSMS if I want to checkout a table structure. Any ideas on how to get this solved?

Error show in yellow

EDIT

Please stop answers specifying to update Azure SDK, it's not related and has not worked

like image 709
Chisko Avatar asked Jun 29 '16 04:06

Chisko


People also ask

How do I link my Azure SQL Database to Visual Studio 2022?

Open your project in Visual Studio. In Solution Explorer, right-click the Connected Services node, and, from the context menu, select Add Connected Service. In the Connected Services tab, select the + icon for Service Dependencies. In the Add Dependency page, select Azure SQL Database.

Is Azure SQL Database fully compatible with Microsoft SQL Server?

Azure fully supports running any edition of SQL Server on IaaS (VM). Combined with 'Always On' availability groups you will be able to achieve full compatibility with legacy on-premises SQL installs.


1 Answers

Use that latest Visual Studio 2019 Community edition, which contains the latest version of SQL Server Data Tools with SQL Server Object Explorer

like image 142
ErikEJ Avatar answered Oct 14 '22 18:10

ErikEJ