Geek Answers Handbook

How to create tables in azure windows?

I am new to windows azure. Someone tell me the process of creating a database and tables in azure windows and how to connect to this connection with the application. We have a window azure account.please clarify my doubts. to deploy the rest of the wcf services in the cloud, let me know the links.

Thanks,

+4
source share
3 answers

Click on the database server in the management portal. The first thing you need to do is manage the allowed IP addresses that can access this server / database. Allow the local IP address. After that, you have 2 options:

  • Using Sql Server Management Studio - it does not have a table editor, and you will need to write T-SQL scripts manually.
  • Use the Silverlight Database Management Utility - click the URL Management link to access it, as shown in the screenshot below.

enter image description here

+1
source

This is May 2014, and the Silverlight online tool is simply not 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 that you created scripts from existing database tables and want to run this script, you have much more freedom and control with SSMS than on the Internet.

To create a table, note a few caveats. One common is that not all T-SQL is supported, but a typical script from another database table (s), which you ultimately need to disable the two "ON" [PRIMARY] "parts of the create statement

+2
source

Since you cannot have wizards for adding / editing tables, restrictions or keys for Azure DB , even if you connected it through MS SQL Server Management Studio , you can use RazorSQL for this purpose. This gives you the feeling that you are playing with your azure database in the management studio, just like with your regular database.

0
source

More articles:


All Articles