Skip to Content
Migrating Applications to the Cloud with Azure
book

Migrating Applications to the Cloud with Azure

by Sjoukje Zaal, Amit Malik, Sander Rossel, Jason Marston, Mohamed Waly, Stefano Demiliani
December 2019
Intermediate to advanced content levelIntermediate to advanced
494 pages
11h 41m
English
Packt Publishing
Content preview from Migrating Applications to the Cloud with Azure

Using your database in the portal

It's time to start using our Azure SQL instance. Find your SQL databases in the Azure portal and go to the Query editor (which is in preview at the time of writing). You'll need to log in using the admin user and password that you used when creating the server. Using Active Directory Single Sign-On (AD SSO) is supported, but is not in the scope of this chapter. Once you're logged in, you can create, save, open, and run queries, and you can edit data. The first thing we're going to do here is run a query to create a table. So, run the following query:

CREATE TABLE dbo.Person(  Id int NOT NULL IDENTITY (1, 1),  FirstName nvarchar(255) NOT NULL,  LastName nvarchar(255) NOT NULL,  PRIMARY KEY (Id))

If you're used ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Migrating Applications to the Cloud

Migrating Applications to the Cloud

Steve Swoyer
Microsoft Azure: Planning, Deploying, and Managing the Cloud

Microsoft Azure: Planning, Deploying, and Managing the Cloud

Julian Soh, Marshall Copeland, Anthony Puca, Micheleen Harris

Publisher Resources

ISBN: 9781839217470Supplemental Content