Azure 1: Creating Your First Azure SQL Database



How to Create a Windows Azure SQL Database

Steps

Creating a Windows Azure SQL Database

  1. Log in to your Windows Azure management portal.
  2. Click on the NEW button in the bottom left corner.
    Then, it will show you a wizard.
  3. Choose Data Services from the first pane, then select SQL Database.
  4. Select Quick Create.
    • It will show a dialog, to enter name, select server and data center’s region for your database.
  5. Enter the name for your database, and choose New SQL database server in the SERVER if you don’t have any.
  6. Choose a login name which will be your username to access the database.Enter a strong password to meet the following requirements.
    • The password must meet the following requirements:
      • More than eight characters in length
      • Does not contain all of the login name
      • Contains characters from at least three of the following categories:
        -English uppercase characters (A through Z)
        -English lowercase characters (a through z)
        -Base 10 digits (0 through 9)
        -Non-alphanumeric characters (example: !, $,  %)
  7. Click Create SQL Database.Then you will see the following process.
    When the process is completed, you will see your database name in "'all items"' list in management portal. Now your database is created successfully!

Allow your IP address for your client app to connect to the server

  1. Manage firewalls.To allow your client app to connect to your database, you need to add client pc’s IP address to allowed list. To do so -
    • Click on SQL Databases in management portal. You will see a list of current databases in your Management Portal.
  2. Click on Cars database.
  3. Click on Dashboard in menu.
  4. Click on “Manage allowed IP addresses” link in Quick Glance.
  5. Click on Add to the Allowed IP Address against your current client IP Address
  6. Click on Save button in the bottom bar.
    • Now you are done managing your database connectivity settings. You can now connect your database to your client app.

Make Some Changes to Database

  1. Add some table to the database.To do so -
    • Click on Databases.
    • Click on Cars database
    • Click on “Design your SQL database” link in Cars database management window.
      • A new Window will open.
      • Put your username and password you entered for your database in this window.
      • Click on "Log On" button. Now you will see the SQL DATABASE Management Portal.
      • Click on Design in the bottom left corner.
      • Click on New Table to create a new table in database.
    • Click on "Identity?" against column ID
    • Make columns as shown in the image below.
    • Click on Save.
    • Click on Data.
    • Add some rows of data
    • Click on Save.

Checking Database Connectivity

  1. Copy Connection String from your Cars database Dashboard.To do so -
    • Go to Dashboard and click Show Connection Strings in Quick Glance.
    • Copy the ADO.NET Connection String
      and replace the "default password" with the password your entered in credentials of database.
    • Make a simple console application in Visual Studio and enter this code in the Main() function.
    • Collapse | Copy Code | try
      {
      Console.WriteLine("Creating Connection");
      var conn = new SqlConnection(/* CONNECTION STRING HERE */ );
      var cmd = new SqlCommand("Select * From Manufacturers", conn);
      Console.WriteLine("Opening Connection!");
      conn.Open();
      Console.WriteLine("Connection Opened");
      Console.WriteLine("Executing Query");
      var result = cmd.ExecuteReader();
      Console.WriteLine("Query Executed!");
      Console.WriteLine("Manufacturers found in database:");
      while
      (result.Read())
      {
      object[] rowArr = new object[result.FieldCount];
      result.GetValues(rowArr);
      Console.WriteLine("\t"+rowArr[1]);
      }
      Console.WriteLine("Closing Connection!");
      conn.Close();
      }
      catch (Exception ex)
      {
      Console.WriteLine("Error Occured\n"+ ex.Message);
      }
      Console.Read();
  2. Run the application.
    • It gives the following output, which means that everything is running OK and the SQL query is run against the server successfully, returning the rows of data.





Video: Create Azure SQL Database In Azure Portal

How to Create a Windows Azure SQL Database
How to Create a Windows Azure SQL Database images

2019 year
2019 year - How to Create a Windows Azure SQL Database pictures

How to Create a Windows Azure SQL Database forecasting
How to Create a Windows Azure SQL Database forecast photo

How to Create a Windows Azure SQL Database photo
How to Create a Windows Azure SQL Database images

How to Create a Windows Azure SQL Database How to Create a Windows Azure SQL Database new photo
How to Create a Windows Azure SQL Database new images

picture How to Create a Windows Azure SQL Database
images How to Create a Windows Azure SQL Database

Watch How to Create a Windows Azure SQL Database video
Watch How to Create a Windows Azure SQL Database video

Forum on this topic: How to Create a Windows Azure SQL , how-to-create-a-windows-azure-sql/
Communication on this topic: How to Create a Windows Azure SQL , how-to-create-a-windows-azure-sql/ , how-to-create-a-windows-azure-sql/

Related News


City Apartment with Traditional Style in L.A. by Michael Armani Design Studio
Fish Oil For Weight Loss – How It Works, Dosage, And Health Benefits
Have You Outgrown Your AcneProducts
Keep Your Feet Happy
Roasted Curry Cauliflower
10 Grey-Coat Outfits That Are Making Us Feel Very Chic
How to Make Your Ex Miss You
Diabetes May Be Bigger Threat to the Female Heart
Homemade tips and remedies for tanning skin
The Definitive Guide to Covering Up a Poop Smell



Date: 12.12.2018, 13:35 / Views: 32282