Time
14 hours 28 minutes
Difficulty
Intermediate
CEU/CPE
15

Video Transcription

00:00
Hello, Siberians. Welcome to Lesson 3.3 Off Medea Tree off. Discuss stated Microsoft as your architect design.
00:08
So here is a list off all the tasks that will be covering in this demo.
00:13
Let's start out by reviewing the migration scenario.
00:18
We have to environment. We have an azure on on on premises environment.
00:23
In hasher, we have a Web service that is Austin, the Tailwind e Commerce site. On premises, we have the Windows 2000 and 12 7 that is running Sequel 2012
00:35
Shopping catalogue of R E Commerce site is hosted on this on premises secrets ever.
00:42
Right now I mean the Tailwind e commerce sites
00:46
on as you can see the site as a list off different items in the shopping catalogs, the hardest items and all the information that you're looking at here I start in the on Premises sequel database ever.
00:59
Here is my own premises sequel database Ever. You can see it as this database called tail winds and here at the different tables that contains information about the products on the site. What you'll be doing is creating a Jessica database, which would be a database migration targets
01:17
and we will be creating on as your database migration service, which will be using to complete the migration scenario from on premises overto Azur.
01:29
Well, then switch our website from using the on premises Sicko database using the Azure sequel database. Let's move to the next task, which would be to create a new I just secret database. Right now, I'm in the Azure Pato.
01:42
If I click on create a resource on typing sequel database
01:49
and I click on sequel database, I can click on the create option. Andi. I'm presented with a menu to enter the details for my new sequel database.
02:00
I can call this Is it. Tour is over one as your D B test, or you can call it any name that you prefer.
02:07
I can select the sever that will be lost in this sequel database. Remember when we're looking at a teary? We talked about this ever, not bean, where we specify our computer off storage resources. It's just a logical administrative construct because a sequel databases and elastic pools
02:27
have to be in the sequel server, which on administrative construct
02:31
and this gets out, Lincoln creates new and I'll go creating new server.
02:38
I'll call Leeds Sever,
02:42
and I'll specify on admin Logan.
02:49
I can specify the location why this database would be him.
02:54
And this is where I can specify if I want to use an elastic pool or not. I want to use an elastic pool. It means I'm gonna have a group off databases star be sharing the same computer resources.
03:07
In this case, I'll select snow, and I can go ahead and configure the database to specify what thehe amusing so you can see for the vehicle model. The treaty is general Propose I for scale on business critical models
03:22
on why, if I go back to the normal detail, you model or did, did you purchase and model? We have the basic, the standard on the premium.
03:32
So in this case, I'll just stick to the vehicle model. And I lived at
03:38
with two virtual costs and touched two gig off data. I'll just click on apply,
03:44
and I'll go ahead and go to the network in Section. So says this is where we can specify natural connectivity access to this database by default, it specified to say no, Hawk says. I can specify to say
03:57
it's gonna be a public and point, which means it's gonna be accessible over the Internet.
04:00
Andi, I also wants this option. If I'm gonna be using something like Azure Sequel as your database migration service, I want the option to allow, as your service is to be able to access the seven. Also, I have the option to say Go ahead and add my high P address that I'm connecting from to the photo.
04:19
Hadid's to be able to have access to this database are Just click on both of those and I'll go ahead and click on
04:26
additional sightings. So here's where I can restart from back up if I have back off, start somewhere off. Or maybe even a sample database that Mike self provide, and they can specify other information, like the relation
04:40
in this case. I also have the option to start the advanced data security. They are the advance trade protection. I'll just quiet and seeing knots now for that
04:49
on our great and Review and creates this database and I'll click on creates
04:56
the next one that are between is I'll be creating on azure database migration service.
05:02
So this is what we have our needs to creates the database migration service that will use to complete our migration scenario. I'm back in the other pot over here
05:13
if I click and create a resource on, I said for database migration service,
05:20
I select the option and I click on Creates
05:25
so before actually click on creating and system off. The options are scenarios that are possible, which the service are great and click and create.
05:33
I can specify what same things, like the resource group that this database migration service will be in.
05:42
I can specify in name for the service, and I'll call this is that to reserve a one
05:47
d b make
05:49
seventh.
05:51
I'll specify the location for that which are lived that issued yourself on. This is where I can specify the price in tear
06:00
the price in tear.
06:01
It's what's gonna detect what I can do. Online migrations are only offline. Migration standard only support offline migrations Wife I select Premium is supportable online and offline migrations are quiet and select that on our click Apply
06:16
in this case. I'll go to the network in section where I can either specify this be connected to an existing
06:23
virtual network. I can create a new virtual network. I'll create a new virtual network
06:30
as your DP mix of East as Phoenix
06:33
our review and creates on a quiet and click on Creates.
06:38
And that begins the creation off our azure database migration service.
06:44
This could take about 15 minutes to create. So what I've done is I've created the sequel data visit. I'll be using this my target earlier,
06:53
and I've also created the database Migration Service, So go ahead and used that for the rest of this demonstration.
07:01
The next thing that out, though, is how be downloading the database migration assistance to our own premises. Sickle database on. I'll be doing an assessment off its readiness to migrate to Azure sequel.
07:15
So here I am on my own premises. Sequel Database. Sever.
07:20
I'm currently on the page to download the database migration Assistant Vision 5.0.
07:27
All you need to do is just such which your favorites such engine for Microsoft Data Migration assistant and you get to the speed.
07:35
I'll go ahead and click on Download,
07:39
and I'll go ahead and save this to download completed our quiet and run its and I'll go similar process that you probably familiar with.
07:50
I'll select the option to launch the data migration assistance and a Guidant Lincoln finish.
07:57
Now we have the data migration assistant opened our great and creating new projects.
08:03
Our colleagues
08:05
confirmed to as, ah, projects
08:13
the assessments types. I want to assess the data base engine on Integration Service's House Select Database Engine.
08:18
What's this sauce type? It's a sequel. Sever on What's the tie? Get several types, so he has waken Select. I want to move it to a managed instance. Type what? I just want to maybe try your secret database out. Leave that as your sequel database on DI can specify assessment on migration.
08:35
So in this case, I'll only be using it for assessment while use the database migration service for migration.
08:41
If I go ahead and click on Creates,
08:46
I can select what I want to check for database compatibility and feature parity in this case
08:50
on our great and click on next,
08:54
you can go ahead and had sources. In this case, I can't specify my seven name.
09:00
I'll just type in the co host
09:03
and I'll specify sequel authentication. Our pretended credentials for my database
09:13
Go ahead and select the option to trust. Several certificates are clicking connects. It identified the database that exists on my local. Sever our quiet and select that a now click on heart.
09:26
Now its added that database on our click on start assessment.
09:33
This will take a few minutes to complete,
09:35
so it's completed in this case and what it's letting me see it. It's trained me issues around
09:41
compatibility
09:43
issues, off feature parity issues. So in this case, it's great because I have no compatibility issues that were detected. If I go to sick or several feature poverty issues,
09:54
it's I light into me that
09:56
I just see quote doesn't support any analysis service. So because I have s A s in installed locally, it's letting me know that I won't be able to use that our niche to migrate that savage Treasure Analysis service
10:09
and also because I have SSR is installed, deployed locally. It's also letting me to know that it's not supported in Najaf Seiko database that so there's a phrase that I needs to find a sudden solutions to. If those features that I intend to continue using,
10:26
I can use this option right here to upload this data out this information to assure my great so I can centralize the visibility of assessment across several applications and database.
10:39
The next thing that I'll be showing you is the migration off Asako schema on migration off the secret data from the on premises Sever Toe Ahjussi Course ever
10:54
visual representation off what I'll be doing now
10:56
I'll be using the database migration service are creating new projects there that will complete the migration for me.
11:03
I'm back in the azure Pato,
11:07
the database that I'm gonna be using in my case of a distant abyss called March 20 months to a sicko D B
11:15
on database migration service that I'll be using is the service over here. So I'll go ahead and select that service.
11:22
How great and click on new migration projects, and I'll give you the name
11:28
the source of a type of sicko sever. The tie gets will be
11:31
sequel databases, but I want to take this moment to just show you some of the other scenarios to that possible now because my sources say, course ever I can select any of the stargates. Now if I change at myself to any of this other options that I get option changes. If I change that to my sequel decided Thai gets that I can change I can use for that.
11:50
If I change this to how the s decided, I get that I can use. So it does very depending on which social coming from on from selecting something like Mongol baby, I can only migrates. That's two Cosmos day be Mondo di B appear in this case, I'll just stick to sicko severed toe acoustical data base.
12:09
Then I can select the type of activity
12:11
in the first case. What I want to do is I want to migrates to skim off my database on Lee, so quiet and selects came out on the migration. But this is where we can select if we want an offline data migration online that emigration. Remember that whatever option you select as an impact on the down time of your application,
12:30
so skim hourly is what I'll be doing for now. Quiet and click on save
12:33
It's advice inmate around D m A, which I've already done toe verify the readiness off my database to migrate
12:41
away and create and run activity.
12:46
It's gonna ask me for the sauce information. Which database I am I coming from? How? Put in the I P address off my on primacy Quote database,
12:56
I'll select sequel authentication, and I put in my user name and my password.
13:03
How? Go ahead and select the option to trust several certificates on our guy ardently can save.
13:11
Now I can specify the targets, which is the information about my Azure sequel database.
13:18
Now, one of the things that don't need here is our quiet and specify the seven name off where my database exists in That's Theodore C. Course ever.
13:28
That's the information off my azure sea course ever
13:31
are specified. The authentication type, which amusing sickle authentication, and I specified the user name on the past. What?
13:39
How quiet and click on Save
13:41
on Dhe. Then I have the option to select the database sauce on, then the Target's database. In my case, that's that's database over there,
13:52
and I'll leave that option as generate from sauce.
13:58
So if a guy ardently conceived here
14:01
on, I'll give the activity in name,
14:05
I'll click on the validation option. In order to save time, I'll click on Do not validate my databases. But if you're doing this in production, you wants to do some validation.
14:15
How great and click. Save on our great and run the migration.
14:22
So what I would do why this migration is running is our go to another as your photo.
14:28
I'll go under my database.
14:31
My secret database over here
14:33
on defy got a query editor
14:37
and I love gin.
14:41
I should be able to verify wants the skimmer, and I can see here. So the skimmer has been migrated, so everything's looking OK on this end. It's my great at the skimmer, but there's no data that we migrated India. I can verify that very easily.
14:58
On If I glide and executes the query, I can see that there's nothing that was returned if I go under my results, absolutely laughing, and it's gonna be the same for the other table. So it's just a skin at this point. If I go back here and I do a refresh, its trainer's complete that, which is great.
15:16
What I'll do is well and creating a new migration project I'm just going to select my existing projects
15:22
are click on new activity on our select offline data migration.
15:28
So I'll be the sauce, which is my own premises sequel,
15:31
and I have my user name. I'll specify my password in there.
15:37
I'll go ahead and click on Save,
15:39
and I also specify information for my target. So I'll put in the password for my Azure sequel
15:46
and I go ahead and click on Safe to That.
15:50
And this is why I can do some map in. So that's the sauce on my target database. It's that's
15:56
on, def. I wanted to I could set the sources, did you read? Only to avoid changes being made. But I would just live the option for now on a great and say
16:04
safe.
16:07
And once that is done is gonna show me. The tables that exists within my database
16:11
are click on Save. It's gonna give the summary, and I'll give this activity in them.
16:18
I'll say, Do not validate. Also, Quicken, save on a great and run the migration
16:25
so the migration is going to start. At this point, it's gonna take only a few seconds to complete, because I don't have that much data in the data base. It's only five megabytes
16:36
on dhe. It's completed the migration
16:38
Now if I go back to my just sequel, if I go ahead and run the same query again now you can see that we have all those information that's now being migrated over. So if I did the same fearful debut dots
16:53
products
16:56
one query and I can see all this information that's now being populated, So we're looking good. So the next window I will show you is the modification off Mazur Web up
17:06
to use the Azure sequel database that we just migrated to. Just verify that currently I'm using the on premises sequel database on dhe. If I refresh my screen. Oh, that looks good. I can see all my shopping catalogue I times our list that they're nice and fine.
17:25
How go back to my agile Pato and in this case I'll go to my application
17:32
service
17:36
on under my application service are been modifying
17:40
some application settings.
17:42
In particular, the application settings that are modifying is this sequel Connection String HQ
17:48
squinted, pointing on premises out need to go get the connection shrink from my eye. Just sequel database and I need to specify that in here I can find the information about the connections drink by going to the database in Asia.
18:03
Click on connection strings and I have the other that Nets
18:07
connection String Over here. I can copy that. Modify the passwords to include the password for this database, which is what I'll do.
18:18
So I've just modified that
18:22
Andi are great and click okay on our great and click saved that
18:27
that's going to restart the Web application, which should take about a few seconds toe starts once that restudied. What I expect to see is, once I refresh the page, the sickos ever would not be pointing to my just equal. But I'll still have all the information
18:44
that I in my shopping catalogs to being displayed correctly.
18:48
Let's reload the screen,
18:55
and now you can see it's pointing to my Azure sequel database by can still see information about my catalog on Everything looks good. That brings me to the end off this demo.
19:07
Thanks very much for watching, and I'll see you in the next Listen, it brings me to the hand off this lesson. Thanks, right, but for watching and I'll see you in the next lesson

Up Next

AZ-301 Microsoft Azure Architect Design

This AZ-301 training covers the skills that are measured in the Microsoft Azure Architect Design certification exam. Learn strategies to plan for the exam, target your areas of study, and gain hands-on experience to prepare for the real world.

Instructed By

Instructor Profile Image
David Okeyode
Cloud Security Architect
Instructor