Problem

This is my fourth tip that is part of a tutorial to help people that are moving for the first time to SQL Azure. If you did not read my previous articles and want to learn how to create a database in SQL Azure and perform basic configurations, you can read them now and then return to this tip to continue your learning.

  1. SQL Azure Create Database Tutorial
  2. Overview of Basic Configuration Options for SQL Azure
  3. How to use Azure SQL Database features and settings

You should use this article as a tutorial and follow it step-by-step. I will also try to share my experience on the differences that I have found when I was moving from SQL Server to SQL Azure for the first time.

Solution

In this tip I will explain how to work with a SQL Azure database from SQL Server Management Studio (SSMS).

SQL Server Management Studio (SSMS)

If you do not have SSMS installed on your computer then you can download from here.

see more https://www.mssqltips.com/sqlservertip/5218/different-ways-to-connect-to-sql-azure-databases/