I am new in windows azure SQL Database. I just purchase it but there is no desktop tool I have found for managing the database.
我是windows azure SQL数据库中的新手。我只是购买了它，但是我没有找到用于管理数据库的桌面工具。
They provide the online silverlight interface but it is hard to maintain and very time consuming.
他们提供在线的silverlight界面，但是很难维护，而且非常耗时。
Is there any better solution for this?
有更好的解决方案吗?
2 个解决方案
#1
4
You can use the full SQL Server Management Studio to do the majority of the tasks.
您可以使用完整的SQL Server Management Studio来执行大部分任务。
You can download the tool here:
你可在此下载此工具:
http://www.microsoft.com/en-gb/download/details.aspx?id=29062
http://www.microsoft.com/en-gb/download/details.aspx?id=29062
To connect to your Azure SQL database, you need to use the fully qualified server name to connect, e.g.
要连接到Azure SQL数据库，需要使用完全限定的服务器名进行连接，例如。
yourservername.database.windows.net
yourservername.database.windows.net
Also, be aware that when you connect to an Azure SQL DB, you don't get all the same features in the tool as you do for the on-premise SQL Server. For example, you cannot manage replication.
另外，请注意，当您连接到Azure SQL DB时，您在工具中获得的特性并不像在本地SQL服务器上获得的那样多。例如，您不能管理复制。
In some cases this is because the feature is not supported in Azure. In other cases it is just that the management tool has no UI. In this case you have to resort to learning the T-SQL. ALTER TABLE etc.
在某些情况下，这是因为Azure不支持该特性。在其他情况下，只是管理工具没有UI。在这种情况下，您必须求助于学习T-SQL。ALTER TABLE等。
#2
1
Online portal has big limitation - it's impossible to add data into the tabes that contains Guid as column type.
在线门户有很大的局限性——不可能将数据添加到包含Guid作为列类型的表中。
I have Visual Studio 2012 and I have found that "SQL Server Object Explorer" is not so bad for managing data/schemes for Azure Databases - since it's already installed and it's pretty simple to run it from VS during development. I am not paranoic, but I trust Visual Studio more than other 3rd party online tools and services, so I am not afraid to set azure credentials in VS.
我有Visual Studio 2012，我发现“SQL Server Object Explorer”对于管理Azure数据库的数据/方案并没有那么糟糕——因为它已经安装了，在开发期间从VS运行它非常简单。我不是帕罗尼亚人，但是我比其他第三方在线工具和服务更信任Visual Studio，所以我不怕在VS中设置azure凭证。
You can connect to your Azure database as to standalone one - just check server addr on the online portal, it should be something like "servername.database.windows.net".
您可以连接到Azure数据库作为独立的数据库——只需检查在线门户上的服务器addr，它应该类似于“servername.database.windows.net”。
#1
4
You can use the full SQL Server Management Studio to do the majority of the tasks.
您可以使用完整的SQL Server Management Studio来执行大部分任务。
You can download the tool here:
你可在此下载此工具:
http://www.microsoft.com/en-gb/download/details.aspx?id=29062
http://www.microsoft.com/en-gb/download/details.aspx?id=29062
To connect to your Azure SQL database, you need to use the fully qualified server name to connect, e.g.
要连接到Azure SQL数据库，需要使用完全限定的服务器名进行连接，例如。
yourservername.database.windows.net
yourservername.database.windows.net
Also, be aware that when you connect to an Azure SQL DB, you don't get all the same features in the tool as you do for the on-premise SQL Server. For example, you cannot manage replication.
另外，请注意，当您连接到Azure SQL DB时，您在工具中获得的特性并不像在本地SQL服务器上获得的那样多。例如，您不能管理复制。
In some cases this is because the feature is not supported in Azure. In other cases it is just that the management tool has no UI. In this case you have to resort to learning the T-SQL. ALTER TABLE etc.
在某些情况下，这是因为Azure不支持该特性。在其他情况下，只是管理工具没有UI。在这种情况下，您必须求助于学习T-SQL。ALTER TABLE等。
#2
1
Online portal has big limitation - it's impossible to add data into the tabes that contains Guid as column type.
在线门户有很大的局限性——不可能将数据添加到包含Guid作为列类型的表中。
I have Visual Studio 2012 and I have found that "SQL Server Object Explorer" is not so bad for managing data/schemes for Azure Databases - since it's already installed and it's pretty simple to run it from VS during development. I am not paranoic, but I trust Visual Studio more than other 3rd party online tools and services, so I am not afraid to set azure credentials in VS.
我有Visual Studio 2012，我发现“SQL Server Object Explorer”对于管理Azure数据库的数据/方案并没有那么糟糕——因为它已经安装了，在开发期间从VS运行它非常简单。我不是帕罗尼亚人，但是我比其他第三方在线工具和服务更信任Visual Studio，所以我不怕在VS中设置azure凭证。
You can connect to your Azure database as to standalone one - just check server addr on the online portal, it should be something like "servername.database.windows.net".
您可以连接到Azure数据库作为独立的数据库——只需检查在线门户上的服务器addr，它应该类似于“servername.database.windows.net”。