Microsoft SQL Server to Oracle Database Migration Demo

In the demo you will see how database migration tool SQLWays can convert SQL Server to Oracle databases. http://www.ispirer.com/products/sql-s...

---

Closed Caption:

hello this is Adam about tools provided
by ice power systems that helps you in
doing the migration from a database or
scripts migration and this tools are all
graphical tools based on them
come online tool called sequel ways so
this then was particularly particularly
devoted to or to a single server to
oracle database conversion so in first
all that i would like to mention is the
sequel is research that you consume your
screens this Tool Works use a sort of
the base using odbc connection and for
target oracle database it creates
comments for native tools lexical plus
and sickle order so one it when you
start the sequel is reserved your trip
and welcome to the sequel waist with
your page here you need to specify the
end of the license do you have for this
product and you can specify a project
directory where set of files required
for project store information like
datatype makin said informations
objective select for conversion our
options that you've selected during
their to announce immigration process
are stored so I've got one selected here
we can go next one into the store
database page used to specify the user
system DSN name for order bc connection
physical server database the username
and the password only target database
page you need to specify oracle is a
target from the list of the supported
databases you can specify version as a
default the latest version is useful for
of 97.2 survives name
this is a genius or wise name showing up
on your kind computer and I got this one
the username and the password that you
are going to use to lower the objects
into the oracle database
advanced age you need to specify bin
directory where actually called
classical order to others to suicide on
your current computer the rocks are
options it helps you in maintains the
and data Lord and physical order tool
and sickle plus tool for definitions
loading into oracle database so i would
recommend you leaving everything intact
for first run
let's click Next almost / based objects
equerry page you can see all the objects
for the sort of the base specified Entry
view so each table specified in storms
hema and in its own object type in the
source tree view physical server
database and in the target you can see
the same so all the select objects can
be seen in the same tree view internal
database as i'm using the project
director so I've got all the objects
selected here so we can go next on the
specified video and data option speech
there's actually a set of options that
lets you specify the conversion to tune
of the conversion process for sequencer
to oracle database so model most
commonly used options sorry miss human
names and sequel scripts as it helps in
controlling the ways human names are
converted from sequel server to oracle
database
there's also options that controls the
reserve or conversion also i would like
to mention options like datatype mapping
as it can be a global data type mapping
that you can see here and it can be
changed for the whole database
conversion or the local data type maybe
it's when you go to some specific table
you can change it change the data type
making result data type for specific
column in some specific table for the
conversion it has higher priorities and
global data mapping also when turnabout
database conversion
music all his tools i usually show the
option that controls ways the video and
data are converted they can be run in
separate processes so for example if
I've got a lot of lots of data in the
sequel server database and i would like
to not to convert the date and first
round just to check the definitions
conversion from sequencer to oracle
database so I'm going to data options
tab and uncheck export data option in
this case no no date is convert it if I
would like to convert the data only so
I've done with dl conversion and now
that i would like to check the data
conversion so I go to do options pay tab
select sequence cruces instead of junior
global data type mapping and uncheck
junior a deal in this case only data is
converted so there are lots of different
options sexually is it helps you in
tuning of the immigration project in our
in our tool if you need some specific
option just impressed with your
questions will be glad to assist you
want to specify expert file options page
are there are options like export
directory that is using it as an
intermediary positive for all the files
the towel generates when doing the
conversion from sequel server database
to oracle and I've got one specified
here
ok let's click Next on specify in
productions page there are two main
options actually control the input
process
the first one is import to local or more
targeted basically executed from the
local system which means that you have
an oracle client installed your current
computer and you can run the input
process from your current computer from
this location so you can start importing
medical in this case and right after the
expert our tool will start in import
into oracle system answers as another
one option that helps you in providing
information about some remote system
where you would like to run the import
process
using this computer locally so i will
convert all the are making export and
then import into oracle system from this
current allocation so you can see the
expert Ross's quite fast other just a
few objects selected for conversion all
the object is depicted immigration
status page
ok so the fashions are converted the
status is provided as well
now the import process for start so you
can see the import process here in this
immigration status page so and you can
review it here as well as in we can go
to have you export page and go to seek
always look file that depicts the export
process here you can see the comment
that is actually around bicycle ways
tool in batch mode classic always will
just him wrapper for a common line tool
statistics regarding the exported
objects statistic about the conversion
process was it has filed or no answer
overall statistics for the number of
objects extracted lives of coordinates
session seen from information about the
export process can be reviewed in sick
always report HTML file you can see here
so there's an object summary page number
of data for tables lines of code for
business logic objects summer
information total here information for
each object type stored procedures
functions triggers and the information
about modifications applied to the
conversion process are usually a
reference to addition of some parameters
and returns statements in this session
so this is a sequel is report file and
as for the import process their sequels
I'm feed look file that depicts the
import process into oracle system
actually this are they
this is the information provided by
Oracle server to our tools so there's no
control the input process for school
wasted Justin's initiates the import of
one by one the comments for single
orders equal plus in oracle database
ok so as for the files generated for
this process you can see that for tables
for example there are generally generate
the single file the dll file with the
command
source and its sequel and in the same
file also there are generated text while
visit data control file with a law
dating file comment for sequel order
tool and the betcha
but a file with school plus and sickle
order our to specification for
maintaining the Lord of definitions and
data accordingly in to the target data
piece also after the import for each
table you'll see a log file where you
can see a the number of rows red and
successfully loaded or skipped or
rejected when doing the Lord into oracle
database as for stored procedures for
business logic objects you can see the
single file that contains the source and
eat secure land in one file and the bed
file with the single glass tool are
calling security mystical statement
inside is equal file so our this is
farcical with your tool works and the
files it provides after the conversion
process so we can now let's serve open a
secure his commander and civilly studio
tools that are defined to help you in
maintaining the conversion for from
micro sequencer to oracle database so
our signal for example is equal a studio
works with one straight to the time so
you can provide some sickle cold here
like let's go to the export directory
and maybe open some of this open some
trigger for a conversion
we can copy it here as a source
ok so we've got a single server some
trigger with some business logic inside
let's make a conversion of it from left
right pane we specify source and target
let's click from you can see so actually
in a row cycleways look that the game
comment line is provided here for doing
the conversion from sequencer to oracle
database you can see that the number of
lines of code converted and wednesdays
they were felled on all the result of
the conversion can be compared in both
left and right pain so you can see how
the trigger has been converted from
single server from for each statement
trigger into for each row trigger in
oracle database as the references to
delete it and inserted where change to
New and Old now when do the conversion
to work this is a example of secure a
studio work and ask for cyclists
commander you can see it here so the ad
is the same it can work with the scripts
conversion but there a difference is it
it can convert multiple steps at a time
so for example we've got some microsoft
single Sarah into oracle conversion like
this one so get some scripts in our
source you can see the required simple
examples of dynamics equal statements
for example so let's convert them from
source to target database we just can
specify a few files for conversion from
left to right pane microsoft sequel
server as a source oracle as a target
now let's run the conversion
so you can see again that the same
article with common line is used for
maintaining this conversion from one at
the base to another and you can see how
they conversion is performed so each
file one by one is converted from sequel
server to oracle database
ok so now let's see the results of the
conversion so we can go to a sickle SP
exact file and compare board the sole
source and secure land from sequencer to
oracle database and actually saw the
conversion is quite simple here now it
is everything converted into easy cutie
media statement from sickle sure to
oracle so this way you can convert both
source and the source target from
sequencer to oracle database and also
hazards opportunity to specifier the
whole folder for conversion or a few
folders for conversion so you can
specify this one this one for conversion
process when you click runs are also
only edit file mask that lets you
specify their file situated line
extension of files to would like to
convert from Microsoft circle serve to
oracle database
ok so this is all information in bars
the tools that are our company as fire
systems provides for the database
migration from sequencer to oracle
database
this suggests in review of the figure
tools and features a supported so if you
need additional information about the
conversion that we support for our
torture centers with all the questions
and we'll be glad to assist you in your
migration projects
thank you very much for your attention
bye