CODEWITHSUNDEEP
azureazure-sql-database
B. Clay Shannon-B. Crow Raven
B. Clay Shannon-B. Crow Raven

Reputation: 10237

How to add SQL DB tables to Azure?

I have signed up for Azure, created a SQL Server item, but cannot see how to, from there, create a DB (create and design the tables, IOW the DDL part of things). Is this something I need to do with the SQL Design Tools, and then export this from Visual Studio / import into the Azure account? Or how is it done?

Upvotes: 0

Views: 636

Answers (3)

cillierscharl
cillierscharl

Reputation: 7117

If you don't want to use the SSMS as other have suggested you can use the silverlight management tool online to execute TSQL Commands; the upside of this is that you have designer support which SSMS lacks.

Once you have selected your DB in the Azure portal click the manage button:

enter image description here

From there a new window will open where you will have to log into the SQL Server.

Once you have logged into your SQL Server you will have the option to create new tables, create procedures etc.

enter image description here

One handy hint, if you go into your SQL Azure details screen you will notice a section to retrieve connection string snippets that may come in handy hooking up your back-end to your application:

enter image description here

Upvotes: 2

Fred Gassmann
Fred Gassmann

Reputation: 129

You can connect to your database in Azure through Visual Studio and/or SQL Server Management Studio (SSMS).

Check this link for details.

SQL Azure Management

Upvotes: 1

Leon Cullens
Leon Cullens

Reputation: 12476

You can install SQL Server Management Studio to connect with your SQL Azure database, and from there you can create tables in the designer, or by entering SQL queries.

Keep in mind that you have to whitelist your IP address in order to access the database. Azure uses whitelisting, meaning that only authorized IP addresses can connect to the database.

Upvotes: 1

Related Questions