hello everyone I'm restaurant I'm group program major for data migrations and
today I'll be talking about unleash your data from non-microsoft data platforms
and in throughout this conference you're going to hear how great the modern data
platforms from Microsoft is and one of the things that you might consider how
to migrate and leverage this great new functionalities and new products with
your existing environment so quite a lot of the customers that we talked with is
they consider migrations there are several reasons for it for business
digital transformation compares the pressure market opportunity is an
important part of it and new platforms allows you to do that much easier and
faster out there technical wise I think it's improved performance definitely is
an important part of it security improve security in there but also the features
like greater insect I mean we are talking with the modern data platforms
doing actual analytics on your transactional systems that's very
exciting and is a very new way of thinking about analytics in there
operationally obviously we have the Microsoft always a total cost of home
ownership and return on investment is very important customer satisfaction and
diversification and consolidation is important so what we are going to do in
here is to talk about migration tools and methodologies my team's work on a
methodology where we define assess and design migrations so when you decide to
move from sybase my c cool db2 or oracle we do have a tool called sequel server
migration assistant that allows you to go to modern data platforms like sequel
server and sequel uh sure and when we do that we define assess and design then we
remediate the challenges that we find to move to the new platform we mitigate
those areas test it look at it again if everything works that we deployed to the
production so with that let me show you the secure
server migration assistant it's just a made mo so let me open up the sequel
server migration assistant this SMA and let's create a new project for it let me
change the name of it data amp Oracle so we'll move from Oracle to one of the
modern platforms so if you look at it you can actually do sequel Azure sequel
v-necks for Windows and Linux versions as well if you are any of the preview
customers for this demo we'll do a sequel 2016 so we connect to oracle data
on this machine and and look at the standard database one of the databases
called HR so we connect to the Oracle and it basically connects and gets the
information from there let's see if everything is there here is this the HR
database that we are interested we click in there then connect the sequel server
and it's a sequel 2016 box that runs on this machine he says that HR does not
exist so I put the HR in there that's the interest we are doing and it created
that so if you look at the sequel server out there you're going to see that HR
database is created so let's look at the sequel server studio to be able to see
if it's really created it so let's look at the sequel server management studio
look at the databases there's nothing exists because I didn't refresh it let
me go to refresh the server here this HR database standard table there's nothing
in there just the standard database that's just been created so we go in
there and look at the Oracle and we convert the schema so what it basically
does it goes in there and converts all the schema from HR 22 sequel server all
the pl SQL code related business as well so we
also see the errors so if it's certain user types server created or Oracle
types that we don't support in sequel server it gives you the information what
needs to be done it also gives you how long at the wall / so we have a
historical data to be able to estimate how long a developer will need to stand
to be able to do that so total estimated manual conversion time is about you know
40 minutes for this task for this small database so to be able to go and
manually change that so we got the schemas out there HR so we put in there
then we synchronized with the database so here you can actually drill down and
see pl/sql translations you can actually go drill down all the different object
levels or from the Oracle to sequel server their ways so we created the
schema let me refresh the sequel server database the HR database is all of them
created all the day tables that comes from the HR database but if you look at
it and let's look at the employee database in there is select origin rose
there is no data in there we just created an empty version of oracle
database in psycho Server 2016 so let's go back to the tool and and look at the
different things that we can do now here we basically go in there and say migrate
data so it basically goes in there in details we connect to oracle again then
the sequel server it basically migrating the data directly from oracle into the
sequel server so we got some data in there let's check if it's really working
or tool so let it select thousand again yes all the data mode from Oracle to
single server seamlessly and this is a very easy way to be able to do that if
you notice is a very easy user interface and it allows you it guides you through
it tells you what needs to be done before you migrate everything in there
and if needs to be changed the things like virtual tables virtual databases
that you can easily migrate the seco server different areas things like a
flashback tables in oracle moves to tempe be in sequel server in memory
tables from oracle to see cool in-memory tables virtual private databases in
oracle to row level security in sequel server so we do really complex
migrations from oracle environment to sequel server environment well as you
seen in the demo migration with secure server migration assistant ssma is very
easy it allows you to estimate migration course simplified migrations you do very
complex Oracle environments like virtual tables and virtual databases into a
sequel server environment it saves you time and money so what I strongly
recommend is to go and download sequel server migration assistant from the web
for free and experience it and see how is it to move from your existing
databases to a modern data platform thank you very much