O'Reilly logo

Microsoft SQL Azure: Enterprise Application Development by Jayaram Krishnaswamy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Connecting to SQL Azure from SQL Server Management Studio

The SQL Azure Portal can manage servers, databases, and firewall settings as seen earlier. However, if you want to work with the databases and/or create objects you need an external utility. SQL Server Management Studio R2 provides the ability to work with databases by providing T-SQL support. There are other tools to connect to SQL Azure. SQL Azure supports only a limited set of features that SQL Server 2008 is capable of as described earlier in this chapter and all these features can be used in SSMS once you are connected to SQL Azure Server.

Connecting to SQL Azure from SSMS

Connecting to SQL Azure from SSMS is like connecting to any of the local SQL servers. To do this, you will need ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required