.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> Azure >> Post New Resource Bookmark and Share   

 Subscribe to Articles

SQL Azure - Import Scripts in Azure portal

Posted By:Karthikeyan Anbarasan       Posted Date: June 28, 2011    Points: 200    Category: Azure    URL: http://www.dotnetspark.com  

In this article we are going to see how to do an import database scripts available in SQL Azure management portal.
 

Introduction:

In this article we are going to see how to do an import database scripts available in SQL Azure management portal.

Overview:

We have seen in our earlier articles on how to manage a database by creating tables, views, stored procedures directly in the azure portal, now we are going to see on the options available to Import an existing available scripts to run on the azure portal.

In a traditional SQL Server locally we will create all the scripts and run the required scripts on to the server-based on the needs, similar wise we can import the whole script to the Azure portal and use it as per our requirement. Let us see on the options how to do an import using the Azure portal step by step

Steps:

Log in to the Azure portal using the below link. You can see the screen look similar to below

http://www.microsoft.com/windowsazure/

image

Login to the portal using your Microsoft Windows Live credentials with Azure credentials to the management portal and you will see the screen as shown in the screen below

screenshot_02

Now we can see the Database Menu at the bottom left, Click on that will go to the Database Subscription window as shown in the screen below

image

Clicking on the subscription name will provide the complete details of the server created and the new database created as shown in the screen below

image

Now we are going to create a new database using some scripts which we prepared locally. In our sample we have scripts to create small table, view and a stored procedure to import it to Azure database.

Script:

CREATE TABLE [dbo].[Employees](
[EmployeeID] [int] IDENTITY(1,1) NOT NULL,
[LastName] [nvarchar](20) NOT NULL,
[FirstName] [nvarchar](10) NOT NULL,
[Title] [nvarchar](30) NULL,
[TitleOfCourtesy] [nvarchar](25) NULL,
[BirthDate] [datetime] NULL,
[HireDate] [datetime] NULL,
[Address] [nvarchar](60) NULL,
[City] [nvarchar](15) NULL,
[Region] [nvarchar](15) NULL,
[PostalCode] [nvarchar](10) NULL,
[Country] [nvarchar](15) NULL,
[HomePhone] [nvarchar](24) NULL,
[Extension] [nvarchar](4) NULL,
[Photo] [image] NULL,
[Notes] [ntext] NULL,
[ReportsTo] [int] NULL,
[PhotoPath] [nvarchar](255) NULL
)
CREATE TABLE [dbo].[Customers](
[CustomerID] [nchar](5) NOT NULL,
[CompanyName] [nvarchar](40) NOT NULL,
[ContactName] [nvarchar](30) NULL,
[ContactTitle] [nvarchar](30) NULL,
[Address] [nvarchar](60) NULL,
[City] [nvarchar](15) NULL,
[Region] [nvarchar](15) NULL,
[PostalCode] [nvarchar](10) NULL,
[Country] [nvarchar](15) NULL,
[Phone] [nvarchar](24) NULL,
[Fax] [nvarchar](24) NULL
)
CREATE TABLE [dbo].[Products](
[ProductID] [int] IDENTITY(1,1) NOT NULL,
[ProductName] [nvarchar](40) NOT NULL,
[SupplierID] [int] NULL,
[CategoryID] [int] NULL,
[QuantityPerUnit] [nvarchar](20) NULL,
[UnitPrice] [money] NULL ,
[UnitsInStock] [smallint] NULL,
[UnitsOnOrder] [smallint] NULL ,
[ReorderLevel] [smallint] NULL ,
[Discontinued] [bit] NOT NULL
)

Create view [dbo].[Current Product List] AS
SELECT Product_List.ProductID, Product_List.ProductName
FROM Products AS Product_List
WHERE (((Product_List.Discontinued)=0))

Once we are ready with the script we will save it in a file Database Script.sql and now we are ready to do an import.

Now let us create a database (Check my earlier article on how to create a database in SQL Azure portal). Once the database is created your screen will look like below

image

Now go to the Manage portal by clicking on the Manage button on the top menu as shown in the screen below

image

Now we are prompted to enter the credentials to login to the server as shown in the screen below. This is some like while we enter SQL Server Management Studio we will be asked to enter the login credentials

image

Once we entered valid credentials our page will look like below with the new SQL Azure Management portal

image

Now we have script ready to import to the SQL Azure database we can do that by going to OPEN QUERY window as shown in the screen below

image

Now it will open the window to select the file as shown in the screen below

image

Select the file and Click on Open will open the scripts in the Azure portal window as shown in the screen below

image

Now Select the appropriate tables and click on Execute button at the top to execute the table, views and stored procedures separately. Else if we have scripts arranged in correct order we can execute it as a whole as shown in the screen below

image

Now we can see the commands are executed correctly. We can check the new tables by going to each section menu at the left side as shown in the screen below

Before  doing that we need to click on the refresh button in order to refresh the Schema and get the latest changes as shown in the screen below

image

Now we can see the new tables and the views added in the list as shown in the screen below

image

Conclusion:

So in this article we have seen on how to do an import database script option using SQL Azure Management Portal


 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend