Unable to display SQL Azure table definition in Visual Studio 2013 -
the error getting is:
problem loading: designer encountered error while loading table definition
i can view info within tables within vs fine , can query info too. fresh install on computer.
what have tried:
tried viewing table in both "server explorer" , "sql server object explorer." checked if login credentials has permissions create tables in "management portal." installed ssms , still cannot show design of table tried connecting database using ole db , sql server info providers, still same issue added ip connection server firewall , turned on "windows azure services" set connection timout counter zerothis image of error. generated simple user table testing purposes management portal.
this simple test connect azure database without using project template. first time using sql azure warn you. sure can stick using management portal alter table definition , stuff that, wanting maintain in 1 program.
i found on microsoft forum after struggling hours. still takes age load, preview ssdt tools, did visual editor first time.
posted microsoft on 1/7/2015 @ 1:59 pm:
this bug has been fixed in preview release back upwards 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 details of this.
the prepare included in our next total (non-preview) release.
thanks, kevin cunnane, sql server database tooling team
azure visual-studio-2013 sql-azure
No comments:
Post a Comment