CODEWITHSUNDEEP
azureazure-storage
user1965546
user1965546

Reputation:

How to create tables in windows azure?

I am new to windows azure.Can anyone please tell me the process of creating database and tables in windows azure and how to connect to that connection to application .we have windows azure account .please clarify my doubts.any of pdf books for deploying the rest wcf services in cloud let me know the links.

Thanks,

Upvotes: 4

Views: 12358

Answers (3)

Zeeshan
Zeeshan

Reputation: 3024

Since you cannot have wizards for Adding/Editing tables, constraints or keys for Azure DB, even if you have connected it through MS SQL Server Management Studio, you can use RazorSQL for this purpose. It gives you a feeling like you are playing with your azure DB in management studio, same as you do with your normal DBs

Upvotes: 0

Tom Stickel
Tom Stickel

Reputation: 20421

It is May 2014 and that Silverlight online tool just is not really much better. 

Best approach is to use SSMS (SQL Server Management Studio)  you can even use the free tools tool.   
Connect to your Azure with the portal supplied server url / port ... and then your username /password.

Say you scripted out an existing database tables and want to execute that script, you have much more freedom and control with SSMS than online.

For table creation note that a few caveats, One that is common is that not all of T-SQL is supported and a typical script from another database table(s) you end up needed to strip off the two "ON [PRIMARY]" parts of the create statement

Upvotes: 2

Gaurav Mantri
Gaurav Mantri

Reputation: 136346

Click on the database server in the management portal. 1st thing you would do is manage the allowed IP Addresses which can access this server/database. Allow your local IP address there. After that you have 2 choices:

  1. Use Sql Server Management Studio - It does not have the table editor and you would need to write T-SQL scripts manually.
  2. Use Silverlight based database management utility - to access this, click on the Manage Url link as shown in the screenshot below.

enter image description here

Upvotes: 1

Related Questions