Microsoft SQL Server to Oracle Database Migration Demo

This demo is showing how Ispirer MnMTK 2015 can convert Microsoft SQL Server to Oracle. http://www.ispirer.com/products/sql-server-to-oracle-migration?click=hKHriQBodWs&from=youtube

---

Closed Caption:

how this is the damn about the tools
provided by I spire systems for database
of screws migrations all of them a
graphical tools based on a command line
to call days by a migration and
modernization engine this demo is
particularly devoted to microsoft SQL
server to oracle database conversion for
this conversion will use the following
tools i spare migration and
modernization engine a command-line tool
that can be run in bitch mode and can
perform the automated conversion of a
database or database and application
called provided in scripts
I spire single waste wizard agree to
that is designed to simplify the
database conversion process tuning for I
spire migration and modernization engine
works with the source database using the
audio bc connection I spire migrations
to do agree to that is designed to
simplify the database application
screwed conversion process tuning for
aspire migration and modernization
engine works with one script at a time
aspire migration commander agree to that
is designed to simplify the database or
application scripts conversion process
tuning for aspire migration and
modernization engine works with several
scripts at a time
for this demo we have prepared a
database in microsoft SQL server you can
see its contents open microsoft SQL
server management studio
for the migration purposes we have
prepared an empty database on oracle
server called ms s-curl to aura
let's convert this database using a
spire Eminem Tiki 2015
for this purpose we have a spy recycle
waste wizard which you can see on your
screen
this tool works with the source database
using the odbc connection and for target
oracle database it creates commands for
native tools when you start aspire
sickle with resort UCI spire single
wizard welcome page here you need to
specify a license that you have for this
product and a project directory were a
set of files required for project
information like datatype mappings a
little fireman's object selected for the
conversion options that you selected
during the tuning up of the migration
process is stored
well I've got it selected here we can
click Next on choose the source database
page you need to specify a user system
DSN name for already bc connection for
microsoft SQL server database a username
and a password
also I'd like to mention that it is
recommended to choose a user that has
appropriate rights to work with system
tables in microsoft SQL server because a
lot of additional information is
extracted from microsoft SQL server for
a conversion of business logic from
microsoft SQL server to oracle
on choose a target database page you
need to specify oracle as a target from
the list of the supported databases to
make an import you need to specify port
servicename the username and the
password that you are going to use to
load the objects to oracle on specified
database objects or query page you can
see all the objects of the source
database specified in a tree view each
table is specified in its own schema and
its own object type in the source review
for microsoft SQL server is a target
pain you can see the tree view of the
selected objects as i'm using the
project directory
I've got all the objects selected here
so we can click Next on specified detail
and data options page there is a set of
options that helps you with tuning out
the conversion process for microsoft SQL
server to oracle the most commonly used
option is a meat skimmer names in SQL
scripts that helps you with controlling
the way the skimmer names are converted
from microsoft SQL server to oracle you
can specify yes if you would like to
remove all skimmer names from the
conversion from microsoft SQL server to
oracle there is also an option called
replace reserved words that control so
the reserved words conversion you can
see it here
also i would like to mention an option
called datatype mapping that can be
global a local global data type mapping
can be changed for the whole database
conversion
local data that making me so that you
can change the day to death maybe for
some specific column in some specific
table during the conversion the local
data type making has a higher priority
than the global data that mapping
also I'd like to show you the option
that controls the way detail and data
are converted they can be run in
separate processes for example I have a
lot of data in microsoft SQL server and
then don't want to convert the data in
the first run I just want to check the
conversion from microsoft SQL server to
oracle
for this purpose you need to open data
option step and then check expert data
option in this case data will not be
converted
I've performed the detail conversion and
now i want to check the data conversion
so i opened the ideal option step select
generation options instead of global
data type mapping and uncheck generate
the deal now only data is converted
the right a lot of different options
that help you with tuning out the
migration in our tool if you need some
specific options please contact us and
we'll be glad to assist you
i'll specify an expert file options page
the reason option expert directory which
is used as an intermediate repository
for all the files which our tool
generates during the conversion from
microsoft SQL server to oracle and I've
got is specified here there is also
running trace mode option that allows us
to see the commended source and the
equivalent on specify input options page
there are two main options that actually
control the input process
the first one is input to local or
remote target database will be executed
from the local system which means that
have an oracle client installed on your
current computer and you can around the
input process from your current computer
from this location and there is another
option that helps you with providing the
information about the remote system
where you would like to run the import
process so you can make an expert and
then move all the files generated by a
spire mtk 2015 to remote computer which
can be on windows on unix i'm using this
computer locally so we'll make expert
and then input into oracle system from
this current location
in case of the functions are converted
the status is provided as well the
import process has started so you can
see it here on the same migration status
page there is also a view expert page
and cycleways log file that depicts
expert process
here you can see the command that is
actually run by a spire cycleways wizard
in benchmark i spare a single wizard is
just a wrapper for the command line to
the same information about the expert
forces can be reviewed in simple ways
report dot HTML file you can see it here
the reason object summary page volume of
data for tables lines of code for
business logic objects total summer
information information for each object
type stored procedures functions
triggers and the information about the
modifications applied to the conversion
process which is usually a reference to
the addition of some parameters return
statements and attention
as to the input
versus the mystical ways input log file
that defeats import process into oracle
system and actually this is the
information provided by Oracle server 2
over 2 so there is no control of the
import process for sickle waste wizard
it just initiates the import of commands
one by one into oracle database
as to the files generated for this
process you can see that for tables and
SQL file a dll file with a demented
source in its equivalent in the same
file are generated
there is also a bitch file with
specification for maintaining the Lord
of definitions and data into the target
database
as to stored procedures in business
logic objects you can see the SQL file
that contains the source and its
equivalent in one pile
and the bed file with commands which
execute the SQL statement in the SQL
file
this is how I spire single waste wizard
works you have seen the file city
provides after the conversion process
now let's check the conversion results
let's open SQL Developer utility in
oracle and check whether the objects
were converted to oracle in order to
check the validity of the converted
business logic we need to run one of the
stored procedures in microsoft SQL
server and oracle and compare the
results
let's choose a stored procedure for the
conversion for this purpose as you can
see the procedure contains cursor
statements and loop statements
let's run it and check the result now
let's round the same stored procedure in
the target database as you can see the
result of the same in both databases so
the conversion was successful
now let's open ice by a migration
commander and inspire migrations to do
which are designed to help you with
maintaining the conversion of scripts
from microsoft SQL server to oracle for
example I spy immigration studio works
with one script at a time
let's add some SQL code in the left pane
let's make a conversion of the code from
the left to the right pane we specify
the source and the target and click run
you can see the command line in the role
which is provided here for the
conversion from microsoft SQL server to
oracle the result of the conversion can
be compared in both left and right
brains for your convenience as to aspire
migration commander the idea is the same
it converts creats but the differences
as can convert multiple scripts at the
time so for example we have got several
scripts in our source
let's convert them you can specify a
file or files of the whole directory
now let's around the conversion
you can see that again the same command
line is used for maintaining the
conversion from one database to the
other and you can see how the conversion
is performed files are converted from
microsoft SQL server to oracle one by
one
now let's see the results of the
conversion we can open the SQL file and
compare the source and its equivalent in
oracle
this is all information about the tools
that our company provides for the
database migration from Microsoft SQL
Server torical it is just a brief review
of the tools and the features that they
support so if you need additional
information please contact us and we
will be glad to help you with your
migration projects
thank you for your attention bye