CODEWITHSUNDEEP
azurevisual-studio-2013azure-sql-database
Simple Sandman
Simple Sandman

Reputation: 900

Unable to display SQL Azure table definition in Visual Studio 2013

The error I am getting is:

Problem loading: The designer encountered an error while loading the table definition

I can view the data within the tables inside VS just fine and can even query the data too. This is a fresh install on my computer.

What I have tried:

This is the image of my error. I generated a very simple user table just for testing purposes from the Management Portal.

Example of my issue

This is a simple test to connect to the Azure database without using a project template. This is my first time using SQL Azure just to warn you. Sure I can just stick to using the Management Portal to change the table definition and stuff like that, but I was wanting to keep everything in one program.

Upvotes: 4

Views: 1572

Answers (2)

dave heywood
dave heywood

Reputation: 791

I found this on a Microsoft forum after struggling for hours. It still takes an age to load, but with the preview SSDT tools, I did get a visual editor for the first time.

Posted by Microsoft on 1/7/2015 at 1:59 PM:

This bug has been fixed in the Preview release to support Azure SQL Database Update V12

See http://blogs.msdn.com/b/ssdt/archive/2014/12/18/sql-server-database-tooling-preview-release-for-the-latest-azure-sql-database-update-v12-preview.aspx for details of this.

The fix will also be included in our next full (non-Preview) release.

Thanks, Kevin Cunnane, SQL Server database tooling team

Upvotes: 4

KingCronus
KingCronus

Reputation: 4529

I have found this issue only applies when using the new "Basic/Standard" tier of databases in Azure. If you switch back to the older style "Web/Business" tiers it will start working again.

Upvotes: 5

Related Questions