[Windows Azure] How to Deploy a Database to Windows Azure

最新推荐文章于 2024-11-07 15:10:30 发布
最新推荐文章于 2024-11-07 15:10:30 发布
阅读量136 收藏
点赞数
文章标签： 数据库
原文链接：http://www.cnblogs.com/licheng/p/3266391.html
版权

How to Deploy a Database to Windows Azure

There are several different ways you can move an on-premises SQL Server database to Windows Azure. In this task, you'll use the Deploy Database to SQL Database wizard to upload a sample database.

The School sample database is conveniently simple; all of its objects are compatible with SQL Database, eliminating the need to modify or prepare a database for migration. As a new administrator, try deploying a simple database first to learn the steps before using your own databases.

Note: Review the SQL Database Migration Guide for detailed instructions on how to prepare an on-premises database for migration to Windows Azure. Also, consider downloading the Windows Azure Training Kit. It includes a lab that shows an alternative approach to migrating an on-premises database.

Table of Contents

How to: Create the school database on an on-premises server

Scripts for creating this database can be found in the Getting Started with SQL Database Administration. In this guide, you'll run these scripts in Management Studio to create an on-premises version of the school database.

  1. In Management Studio, connect to an on-premises server. Right-click Databases, click New Database, and enter school.

  2. Right-click on school, click New Query.

  3. Copy and then execute the Create Schema script from the tutorial.

--Create the Department table.
    IF NOT EXISTS (SELECT * FROM sys.objects 
        WHERE object_id = OBJECT_ID(N'[dbo].[Department]') 
        AND type in(N'U'))BEGIN
    CREATE TABLE [dbo].[Department]([DepartmentID][int] NOT NULL,[Name][nvarchar](50) NOT NULL,[Budget][money] NOT NULL,[StartDate][datetime] NOT NULL,[Administrator][int] NULL,
     CONSTRAINT [PK_Department] PRIMARY KEY CLUSTERED 
    ([DepartmentID] ASC
    )WITH (IGNORE_DUP_KEY = OFF))END;
    GO

    --Create the Person table.
    IF NOT EXISTS (SELECT * FROM sys.objects 
        WHERE object_id = OBJECT_ID(N'[dbo].[Person]') 
        AND type in(N'U'))BEGIN
    CREATE TABLE [dbo].[Person]([PersonID][int] IDENTITY(1,1) NOT NULL,[LastName][nvarchar](50) NOT NULL,[FirstName][nvarchar](50) NOT NULL,[HireDate][datetime] NULL,[EnrollmentDate][datetime] NULL,
     CONSTRAINT [PK_School.Student] PRIMARY KEY CLUSTERED   
    ([PersonID] ASC
    )WITH (IGNORE_DUP_KEY = OFF))END;
    GO

    --Create the OnsiteCourse table.
    IF NOT EXISTS (SELECT * FROM sys.objects 
        WHERE object_id = OBJECT_ID(N'[dbo].[OnsiteCourse]') 
        AND type in(N'U'))BEGIN
    CREATE TABLE [dbo].[OnsiteCourse]([CourseID][int] NOT NULL,[Location][nvarchar](50) NOT NULL,[Days][nvarchar](50) NOT NULL,[Time][smalldatetime] NOT NULL,
     CONSTRAINT [PK_OnsiteCourse] PRIMARY KEY CLUSTERED 
    ([CourseID] ASC
    )WITH (IGNORE_DUP_KEY = OFF))END;
    GO

    --Create the OnlineCourse table.
    IF NOT EXISTS (SELECT * FROM sys.objects 
        WHERE object_id = OBJECT_ID(N'[dbo].[OnlineCourse]') 
        AND type in(N'U'))BEGIN
    CREATE TABLE [dbo].[OnlineCourse]([CourseID][int] NOT NULL,[URL][nvarchar](100) NOT NULL,
     CONSTRAINT [PK_OnlineCourse] PRIMARY KEY CLUSTERED 
    ([CourseID] ASC
    )WITH (IGNORE_DUP_KEY = OFF))END;
    GO

    --Create the StudentGrade table.
    IF NOT EXISTS (SELECT * FROM sys.objects 
        WHERE object_id = OBJECT_ID(N'[dbo].[StudentGrade]') 
        AND type in(N'U'))BEGIN
    CREATE TABLE [dbo].[StudentGrade]([EnrollmentID][int] IDENTITY(1,1) NOT NULL,[CourseID][int] NOT NULL,[StudentID][int] NOT NULL,[Grade][decimal](3,2) NULL,
     CONSTRAINT [PK_StudentGrade] PRIMARY KEY CLUSTERED 
    ([EnrollmentID] ASC
    )WITH (IGNORE_DUP_KEY = OFF))END;
    GO

    --Create the CourseInstructor table.
    IF NOT EXISTS (SELECT * FROM sys.objects 
        WHERE object_id = OBJECT_ID(N'[dbo].[CourseInstructor]') 
        AND type in(N'U'))BEGIN
    CREATE TABLE [dbo].[CourseInstructor]([CourseID][int] NOT NULL,[PersonID][int] NOT NULL,
     CONSTRAINT [PK_CourseInstructor] PRIMARY KEY CLUSTERED 
    ([CourseID] ASC,[PersonID] ASC
    )WITH (IGNORE_DUP_KEY = OFF))END;
    GO

    --Create the Course table.
    IF NOT EXISTS (SELECT * FROM sys.objects 
        WHERE object_id = OBJECT_ID(N'[dbo].[Course]') 
        AND type in(N'U'))BEGIN
    CREATE TABLE [dbo].[Course]([CourseID][int] NOT NULL,[Title][nvarchar](100) NOT NULL,[Credits][int] NOT NULL,[DepartmentID][int] NOT NULL,
     CONSTRAINT [PK_School.Course] PRIMARY KEY CLUSTERED 
    ([CourseID] ASC
    )WITH (IGNORE_DUP_KEY = OFF))END;
    GO

    --Create the OfficeAssignment table.
    IF NOT EXISTS (SELECT * FROM sys.objects 
        WHERE object_id = OBJECT_ID(N'[dbo].[OfficeAssignment]')
        AND type in(N'U'))BEGIN
    CREATE TABLE [dbo].[OfficeAssignment]([InstructorID][int] NOT NULL,[Location][nvarchar](50) NOT NULL,[Timestamp][timestamp] NOT NULL,
     CONSTRAINT [PK_OfficeAssignment] PRIMARY KEY CLUSTERED 
    ([InstructorID] ASC
    )WITH (IGNORE_DUP_KEY = OFF))END;
    GO

    --Define the relationship between OnsiteCourseandCourse.
    IF NOT EXISTS (SELECT * FROM sys.foreign_keys 
       WHERE object_id = OBJECT_ID(N'[dbo].[FK_OnsiteCourse_Course]')
       AND parent_object_id = OBJECT_ID(N'[dbo].[OnsiteCourse]'))
    ALTER TABLE [dbo].[OnsiteCourse]  WITH CHECK ADD  
       CONSTRAINT [FK_OnsiteCourse_Course] FOREIGN KEY([CourseID])
    REFERENCES [dbo].[Course]([CourseID]);
    GO
    ALTER TABLE [dbo].[OnsiteCourse] CHECK 
       CONSTRAINT [FK_OnsiteCourse_Course];
    GO

    --Define the relationship between OnlineCourseandCourse.
    IF NOT EXISTS (SELECT * FROM sys.foreign_keys 
       WHERE object_id = OBJECT_ID(N'[dbo].[FK_OnlineCourse_Course]')
       AND parent_object_id = OBJECT_ID(N'[dbo].[OnlineCourse]'))
    ALTER TABLE [dbo].[OnlineCourse]  WITH CHECK ADD  
       CONSTRAINT [FK_OnlineCourse_Course] FOREIGN KEY([CourseID])
    REFERENCES [dbo].[Course]([CourseID]);
    GO
    ALTER TABLE [dbo].[OnlineCourse] CHECK 
       CONSTRAINT [FK_OnlineCourse_Course];
    GO
    --Define the relationship between StudentGradeandCourse.
    IF NOT EXISTS (SELECT * FROM sys.foreign_keys 
       WHERE object_id = OBJECT_ID(N'[dbo].[FK_StudentGrade_Course]')
       AND parent_object_id = OBJECT_ID(N'[dbo].[StudentGrade]'))
    ALTER TABLE [dbo].[StudentGrade]  WITH CHECK ADD  
       CONSTRAINT [FK_StudentGrade_Course] FOREIGN KEY([CourseID])
    REFERENCES [dbo].[Course]([CourseID]);
    GO
    ALTER TABLE [dbo].[StudentGrade] CHECK 
       CONSTRAINT [FK_StudentGrade_Course];
    GO

    --Define the relationship between StudentGradeandStudent.
    IF NOT EXISTS (SELECT * FROM sys.foreign_keys 
       WHERE object_id = OBJECT_ID(N'[dbo].[FK_StudentGrade_Student]')
       AND parent_object_id = OBJECT_ID(N'[dbo].[StudentGrade]'))   
    ALTER TABLE [dbo].[StudentGrade]  WITH CHECK ADD  
       CONSTRAINT [FK_StudentGrade_Student] FOREIGN KEY([StudentID])
    REFERENCES [dbo].[Person]([PersonID]);
    GO
    ALTER TABLE [dbo].[StudentGrade] CHECK 
       CONSTRAINT [FK_StudentGrade_Student];
    GO

    --Define the relationship between CourseInstructorandCourse.
    IF NOT EXISTS (SELECT * FROM sys.foreign_keys 
     WHERE object_id = OBJECT_ID(N'[dbo].[FK_CourseInstructor_Course]')
     AND parent_object_id = OBJECT_ID(N'[dbo].[CourseInstructor]'))
    ALTER TABLE [dbo].[CourseInstructor]  WITH CHECK ADD  
     CONSTRAINT [FK_CourseInstructor_Course] FOREIGN KEY([CourseID])
    REFERENCES [dbo].[Course]([CourseID]);
    GO
    ALTER TABLE [dbo].[CourseInstructor] CHECK 
      CONSTRAINT [FK_CourseInstructor_Course];
    GO

    --Define the relationship between CourseInstructorandPerson.
    IF NOT EXISTS (SELECT * FROM sys.foreign_keys 
      WHERE object_id = OBJECT_ID(N'[dbo].[FK_CourseInstructor_Person]')
       AND parent_object_id = OBJECT_ID(N'[dbo].[CourseInstructor]'))
    ALTER TABLE [dbo].[CourseInstructor]  WITH CHECK ADD  
      CONSTRAINT [FK_CourseInstructor_Person] FOREIGN KEY([PersonID])
    REFERENCES [dbo].[Person]([PersonID]);
    GO
    ALTER TABLE [dbo].[CourseInstructor] CHECK 
     CONSTRAINT [FK_CourseInstructor_Person];
    GO

    --Define the relationship between CourseandDepartment.
    IF NOT EXISTS (SELECT * FROM sys.foreign_keys 
       WHERE object_id = OBJECT_ID(N'[dbo].[FK_Course_Department]')
       AND parent_object_id = OBJECT_ID(N'[dbo].[Course]'))
    ALTER TABLE [dbo].[Course]  WITH CHECK ADD  
       CONSTRAINT [FK_Course_Department] FOREIGN KEY([DepartmentID])
    REFERENCES [dbo].[Department]([DepartmentID]);
    GO
    ALTER TABLE [dbo].[Course] CHECK CONSTRAINT [FK_Course_Department];
    GO

    --Define the relationship between OfficeAssignmentandPerson.
    IF NOT EXISTS (SELECT * FROM sys.foreign_keys 
      WHERE object_id = OBJECT_ID(N'[dbo].[FK_OfficeAssignment_Person]')
      AND parent_object_id = OBJECT_ID(N'[dbo].[OfficeAssignment]'))
    ALTER TABLE [dbo].[OfficeAssignment]  WITH CHECK ADD  
      CONSTRAINT [FK_OfficeAssignment_Person] FOREIGN KEY([InstructorID])
    REFERENCES [dbo].[Person]([PersonID]);
    GO
    ALTER TABLE [dbo].[OfficeAssignment] CHECK 
     CONSTRAINT [FK_OfficeAssignment_Person];
    GO

Next, copy and execute the Insert Data script.

--Insert data into the Person table.
    SET IDENTITY_INSERT dbo.Person ON;
    GO
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (1,'Abercrombie','Kim','1995-03-11',null);
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (2,'Barzdukas','Gytis',null,'2005-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (3,'Justice','Peggy',null,'2001-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (4,'Fakhouri','Fadi','2002-08-06',null);
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (5,'Harui','Roger','1998-07-01',null);
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (6,'Li','Yan',null,'2002-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (7,'Norman','Laura',null,'2003-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (8,'Olivotto','Nino',null,'2005-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (9,'Tang','Wayne',null,'2005-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (10,'Alonso','Meredith',null,'2002-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (11,'Lopez','Sophia',null,'2004-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (12,'Browning','Meredith',null,'2000-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (13,'Anand','Arturo',null,'2003-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (14,'Walker','Alexandra',null,'2000-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (15,'Powell','Carson',null,'2004-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (16,'Jai','Damien',null,'2001-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (17,'Carlson','Robyn',null,'2005-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (18,'Zheng','Roger','2004-02-12',null);
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (19,'Bryant','Carson',null,'2001-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (20,'Suarez','Robyn',null,'2004-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (21,'Holt','Roger',null,'2004-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (22,'Alexander','Carson',null,'2005-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (23,'Morgan','Isaiah',null,'2001-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (24,'Martin','Randall',null,'2005-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (25,'Kapoor','Candace','2001-01-15',null);
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (26,'Rogers','Cody',null,'2002-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (27,'Serrano','Stacy','1999-06-01',null);
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (28,'White','Anthony',null,'2001-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (29,'Griffin','Rachel',null,'2004-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (30,'Shan','Alicia',null,'2003-09-01');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (31,'Stewart','Jasmine','1997-10-12',null);
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (32,'Xu','Kristen','2001-7-23',null);
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (33,'Gao','Erica',null,'2003-01-30');
    INSERT INTO dbo.Person(PersonID,LastName,FirstName,HireDate,EnrollmentDate)
    VALUES (34,'Van Houten','Roger','2000-12-07',null);
    GO
    SET IDENTITY_INSERT dbo.Person OFF;
    GO
    --Insert data into the Department table.
    INSERT INTO dbo.Department(DepartmentID,[Name],Budget,StartDate,Administrator)
    VALUES (1,'Engineering',350000.00,'2007-09-01',2);
    INSERT INTO dbo.Department(DepartmentID,[Name],Budget,StartDate,Administrator)
    VALUES (2,'English',120000.00,'2007-09-01',6);
    INSERT INTO dbo.Department(DepartmentID,[Name],Budget,StartDate,Administrator)
    VALUES (4,'Economics',200000.00,'2007-09-01',4);
    INSERT INTO dbo.Department(DepartmentID,[Name],Budget,StartDate,Administrator)
    VALUES (7,'Mathematics',250000.00,'2007-09-01',3);
    GO
    --Insert data into the Course table.
    INSERT INTO dbo.Course(CourseID,Title,Credits,DepartmentID)
    VALUES (1050,'Chemistry',4,1);
    INSERT INTO dbo.Course(CourseID,Title,Credits,DepartmentID)
    VALUES (1061,'Physics',4,1);
    INSERT INTO dbo.Course(CourseID,Title,Credits,DepartmentID)
    VALUES (1045,'Calculus',4,7);
    INSERT INTO dbo.Course(CourseID,Title,Credits,DepartmentID)
    VALUES (2030,'Poetry',2,2);
    INSERT INTO dbo.Course(CourseID,Title,Credits,DepartmentID)
    VALUES (2021,'Composition',3,2);
    INSERT INTO dbo.Course(CourseID,Title,Credits,DepartmentID)
    VALUES (2042,'Literature',4,2);
    INSERT INTO dbo.Course(CourseID,Title,Credits,DepartmentID)
    VALUES (4022,'Microeconomics',3,4);
    INSERT INTO dbo.Course(CourseID,Title,Credits,DepartmentID)
    VALUES (4041,'Macroeconomics',3,4);
    INSERT INTO dbo.Course(CourseID,Title,Credits,DepartmentID)
    VALUES (4061,'Quantitative',2,4);
    INSERT INTO dbo.Course(CourseID,Title,Credits,DepartmentID)
    VALUES (3141,'Trigonometry',4,7);
    GO
    --Insert data into the OnlineCourse table.
    INSERT INTO dbo.OnlineCourse(CourseID, URL)
    VALUES (2030,'http://www.fineartschool.net/Poetry');
    INSERT INTO dbo.OnlineCourse(CourseID, URL)
    VALUES (2021,'http://www.fineartschool.net/Composition');
    INSERT INTO dbo.OnlineCourse(CourseID, URL)
    VALUES (4041,'http://www.fineartschool.net/Macroeconomics');
    INSERT INTO dbo.OnlineCourse(CourseID, URL)
    VALUES (3141,'http://www.fineartschool.net/Trigonometry');--Insert data intoOnsiteCourse table.
    INSERT INTO dbo.OnsiteCourse(CourseID,Location,Days,[Time])
    VALUES (1050,'123 Smith','MTWH','11:30');
    INSERT INTO dbo.OnsiteCourse(CourseID,Location,Days,[Time])
    VALUES (1061,'234 Smith','TWHF','13:15');
    INSERT INTO dbo.OnsiteCourse(CourseID,Location,Days,[Time])
    VALUES (1045,'121 Smith','MWHF','15:30');
    INSERT INTO dbo.OnsiteCourse(CourseID,Location,Days,[Time])
    VALUES (4061,'22 Williams','TH','11:15');
    INSERT INTO dbo.OnsiteCourse(CourseID,Location,Days,[Time])
    VALUES (2042,'225 Adams','MTWH','11:00');
    INSERT INTO dbo.OnsiteCourse(CourseID,Location,Days,[Time])
    VALUES (4022,'23 Williams','MWF','9:00');--Insert data into the CourseInstructor table.
    INSERT INTO dbo.CourseInstructor(CourseID,PersonID)
    VALUES (1050,1);
    INSERT INTO dbo.CourseInstructor(CourseID,PersonID)
    VALUES (1061,31);
    INSERT INTO dbo.CourseInstructor(CourseID,PersonID)
    VALUES (1045,5);
    INSERT INTO dbo.CourseInstructor(CourseID,PersonID)
    VALUES (2030,4);
    INSERT INTO dbo.CourseInstructor(CourseID,PersonID)
    VALUES (2021,27);
    INSERT INTO dbo.CourseInstructor(CourseID,PersonID)
    VALUES (2042,25);
    INSERT INTO dbo.CourseInstructor(CourseID,PersonID)
    VALUES (4022,18);
    INSERT INTO dbo.CourseInstructor(CourseID,PersonID)
    VALUES (4041,32);
    INSERT INTO dbo.CourseInstructor(CourseID,PersonID)
    VALUES (4061,34);
    GO
    --Insert data into the OfficeAssignment table.
    INSERT INTO dbo.OfficeAssignment(InstructorID,Location)
    VALUES (1,'17 Smith');
    INSERT INTO dbo.OfficeAssignment(InstructorID,Location)
    VALUES (4,'29 Adams');
    INSERT INTO dbo.OfficeAssignment(InstructorID,Location)
    VALUES (5,'37 Williams');
    INSERT INTO dbo.OfficeAssignment(InstructorID,Location)
    VALUES (18,'143 Smith');
    INSERT INTO dbo.OfficeAssignment(InstructorID,Location)
    VALUES (25,'57 Adams');
    INSERT INTO dbo.OfficeAssignment(InstructorID,Location)
    VALUES (27,'271 Williams');
    INSERT INTO dbo.OfficeAssignment(InstructorID,Location)
    VALUES (31,'131 Smith');
    INSERT INTO dbo.OfficeAssignment(InstructorID,Location)
    VALUES (32,'203 Williams');
    INSERT INTO dbo.OfficeAssignment(InstructorID,Location)
    VALUES (34,'213 Smith');--Insert data into the StudentGrade table.
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (2021,2,4);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (2030,2,3.5);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (2021,3,3);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (2030,3,4);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (2021,6,2.5);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (2042,6,3.5);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (2021,7,3.5);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (2042,7,4);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (2021,8,3);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (2042,8,3);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4041,9,3.5);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4041,10,null);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4041,11,2.5);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4041,12,null);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4061,12,null);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4022,14,3);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4022,13,4);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4061,13,4);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4041,14,3);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4022,15,2.5);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4022,16,2);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4022,17,null);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4022,19,3.5);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4061,20,4);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4061,21,2);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4022,22,3);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4041,22,3.5);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4061,22,2.5);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (4022,23,3);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (1045,23,1.5);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (1061,24,4);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (1061,25,3);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (1050,26,3.5);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (1061,26,3);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (1061,27,3);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (1045,28,2.5);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (1050,28,3.5);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (1061,29,4);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (1050,30,3.5);
    INSERT INTO dbo.StudentGrade(CourseID,StudentID,Grade)
    VALUES (1061,30,4);
    GO

You now have an on-premises database that you can export to Windows Azure. Next, you'll run a wizard that creates a .bacpac file, loads it onto Windows Azure, and imports it into SQL Database.

How to: Deploy to SQL Database

  1. In Management Studio, connect to an on-premises SQL Server instance that has a database you want to migrate.

  2. Right-click the school database that you just created, point to Tasks, and click Deploy Database to SQL Azure.

  3. In Deployment Settings, enter a name for the database, such as school.

  4. Click Connect.

  5. In Server name, enter the 10-character server name, followed by .database.windows.net.

  6. In Authentication, choose SQL Server Authentication.

  7. Enter the administrator login name and password that you provisioned when creating the SQL Database logical server.

  8. Click Options.

  9. In Connection Properties, in Connect to database, type master.

  10. Click Connect. This step concludes the connection specification and takes you back to the wizard.

  11. Click Next and click Finish to run the wizard.

How to: Verify database deployment

  1. In Management Studio, in Object Explorer refresh the databases to view the new one you just created.

  2. Expand the Databases folder. You should see the school database in the list.

  3. Right-click on the school database and click New Query.

  4. Execute the following query to verify that data is accessible.

SELECT
        Course.Titleas"Course Title",Department.Nameas"Department",Person.LastNameas"Instructor",OnsiteCourse.Locationas"Location",OnsiteCourse.Daysas"Days",OnsiteCourse.Timeas"Time"
    FROM
     Course
     INNER JOIN Department
      ON Course.DepartmentID=Department.DepartmentID
     INNER JOIN CourseInstructor
       ON Course.CourseID=CourseInstructor.CourseID
     INNER JOIN Person
       ON CourseInstructor.PersonID=Person.PersonID
     INNER JOIN OnsiteCourse
        ON OnsiteCourse.CourseID=CourseInstructor.CourseID;

转载于:https://www.cnblogs.com/licheng/p/3266391.html

weixin_33908217
关注
Pro PowerShell for Microsoft Azure(Apress,2015)
12-21
Readers will find out how to deploy, configure and manage the various components of the Azure platform, from storage and virtual networks to Azure Web Apps, HDInsight clusters and the Azure SQL ...
Microsoft.Azure.Security.Infrastructure
01-12
security, and compliance processes in Azure cloud environments In Microsoft Azure Security Infrastructure, three leading experts show how to plan, deploy, and operate Microsoft Azure with outstanding...
[Windows Azure] How to Create and Deploy a Cloud Service?
weixin_33690963的博客
01-08 134
The Windows Azure Management Portal provides two ways for you to create and deploy a cloud service: Quick Create and Custom Create. This topic explains how to use the Quick Create method to create a ...
How to deploy a web application on Windows Azure
yousuf007的专栏
12-29 707
Windows Azure is anopen and flexiblecloud platform built byMicrosoft, it has been widely spread around the globe. Now I will introduce how to deploy a web application on it. 1. Create and deploy a
[Windows Azure] How to use the Queue Storage Service
weixin_34309435的博客
06-17 225
How to use the Queue Storage Service version 1.7version 2.0 This guide will show you how to perform common scenarios using the Windows Azure Queue storage service. The samples are written in C# cod...
[Windows Azure] How to Manage Cloud Services
weixin_34200628的博客
06-27 219
How to Manage Cloud Services To use this feature and other new Windows Azure capabilities, sign up for the free preview. In the Cloud Services area of the Windows Azure Management Portal, you ca...
[Windows Azure] How to Manage Cloud Services?
weixin_34032779的博客
06-17 190
How to Manage Cloud Services To use this feature and other new Windows Azure capabilities, sign up for the free preview. In the Cloud Services area of the Windows Azure Management Portal, you ca...
[Windows Azure] Windows Azure SQL Database library
weixin_34289454的博客
06-17 198
MicrosoftWindows Azure SQL Databaseextends SQL Server capabilities to the cloud. SQL Database offers a relational database service called MicrosoftSQL Database, and using Windows Azure SQL Database...
[Windows Azure] How to use the Table Storage Service
weixin_34234823的博客
01-08 234
How to use the Table Storage Service version 1.7 version 2.0 This guide will show you how to perform common scenarios using the Windows Azure Table Storage Service. The samples are written in C# cod...
windows azure mysql data disk_性能最佳做法 - Azure Database for MySQL | Microsoft Docs
weixin_39851307的博客
02-05 149
您现在访问的是微软AZURE全球版技术文档网站，若需要访问由世纪互联运营的MICROSOFT AZURE中国区技术文档网站，请访问 https://docs.azure.cn.获得 Azure Database for MySQL 单一服务器的最佳性能的最佳做法Best practices for optimal performance of your Azure Database for MyS...
Building Web Services with Microsoft Azure(PACKT,2015)
08-19
But Microsoft Azure provides a scalable and manageable platform for customers to easily deploy, monitor, and troubleshoot their cloud-based applications. Its seamless integration and inherent support...
go 集成go-redis 缓存操作
最新发布
hlsd的博客
11-07 819
go redis 学习。
Redis实战-利用Lua解决批量插入防重方案
葵续浅笑的博客
11-01 1317
本文介绍了以Lua脚本为基础设计的防重和幂等方案。
windows11安装redis
qq_42985657的博客
11-06 294
下载免安装版本，鼠标点击一下自动下载。解压。
数据库 二
wjj20040809的博客
11-02 792
表与表的关系：核心表mysql/oracle、SQLServer(微软)SQL。
【达梦数据库】Oracle数据库通过DTS工具迁移数据到达梦数据库--索引数量存在出入
weixin_47686079的博客
11-06 47
【代码】【达梦数据库】Oracle数据库通过DTS迁移到达梦数据库索引数量不一致。
Windows Azure入门指南
"这是关于Windows Azure的介绍，涵盖了基础概念、内部结构、服务部署、更新、主机操作系统升级和服务健康等核心内容。" Windows Azure是微软提供的一个全面的云计算平台，旨在帮助开发者构建、部署和管理应用程序及...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值