diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)


Connect to SQL Azure Using sqlcmd – MSDN Article

One of the reasons that SQL Azure is such a powerful tool is that it’s based on the same database engine as SQL Server. For e.g., you can connect to the Microsoft SQL Azure Database with the sqlcmd command prompt utility that is included with SQL Server. The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt.

To connect to SQL Azure Database by using sqlcmd, append the SQL Azure server name to the login in the connection string by using the <login>@<server> notation. For e.g., if your login is login1 and the fully qualified name of the SQL Azure server is servername.database.windows.net, the username parameter of the connection string is: [email protected] This restriction places limitations on the text you can choose for the login name.

MSDN has written a tutorial on how to do this. Take a look and get a feel for how easy it is to get started using SQL Azure:

Share This Story, Choose Your Platform!

Get Latest News

Subscribe to Digital News Hub

Get our daily newsletter about the latest news in the industry.
First Name
Last Name
Email address
Secure and Spam free...