MySQL to Oracle Database Migration Demo

This demo is showing how SQLWays can convert MySQL to Oracle database. http://www.ispirer.com/products/mysql-to-oracle-migration?click=4ZQBaWMoAI0&from=youtube

---

Closed Caption:

hello this is a damn above the migration
tools provided by I spy systems for the
mysql to oracle migration first of all
I'd like to mention that is by systems
provides tools and services for
automating the database and application
migration processes for a variety of
conversion directions the list of tools
supplied for such a kind of animation is
as follows sick away sweetheart that is
a great tool that is designed to
simplify the database conversion process
tuning for basic always command line
tool works with the source database
using the odbc connection cyclists to do
in going to it is designed to simplify
the database replication script
conversion process to union for the
sickles command-line tool works with one
script at a time
sickles commander going to MIT is
designed to simplify the database
replication scripts conversion process
tuning but this equalness command-line
tool works with several scripts at a
time and the comment line tool that can
be run in batch mode and can perform the
automatic conversion of the database
using the odbc connection or the
database and application code providing
screens in this demo I will show you the
my skill to oracle migration using
seaquest resort tearaway studio and
cigarettes commander tools mentioned in
the list provided
first let's start from the sqlways we
start this tool can connect to my skill
database using the odbc connection on so
to migrate from my skill to oracle you
need to provide the ODBC DSN for mysql
on the true source database page also
you need to specify a user and the best
word with the appropriate rights for
making selections from system tables
from mysql and choose a target database
page into truth the target database from
the list of the supported databases as
you can see the oracle database is
specified here also you need to provide
other credentials for the oracle
database for support of definitions and
data Lord using native utilities of this
database all the objects that is kill
ways manages to extract from the mysql
database and represented in a tree view
on the specified database objects
acquire page here you can select all the
objects required for the migration after
that you can specify different options
for automated mysql to oracle conversion
like option that controls the schema
name conversion reserved words
conversion data types conversion
identifier names conversion and etc also
there are options that can help you to
run the definitions and data migration
in separate processes
on the specified export file options
page you need to provide the directory
which serves as an intermediate
repository for the whole migration
process and stores all the automatically
generated files like a secure files with
the converted definitions of the objects
text files with the data prepared to be
loaded into the target database better
or sh files with the comments or native
utilities toward both definitions and
data on windows or on unix-like OS
control files with the Lord data comment
for the SQL lauder tool to load the data
into the oracle database of the mysql to
work migration process is performed in
two steps each of them has separate
login information for the export process
cycleways log files are generated with
information about the objects read from
the mysql database their number number
of rows of data in size of the data per
each table extracted number of lines of
code bridge business logic objects like
use synonyms for procedures functions
triggers packages and etc at the end of
the export block while you can find some
more information for each object that
regarding the number of objects common
size of data number of rows of data or
lines of code depending on the object
type export status and issues if there
are any and the total information for
the whole database export similar
information but in worried about format
is provided in the sqlways report dot
HTML file there is a summary table
with a complete export status and
statistics per each object type and
there is also tables with the list of
objects and more detailed statistics for
each object extracted from mysql
database
is for the import process take aways
generates sequel ways impact lock file
for the import into the oracle database
that contains information about objects
that were loaded and issues during the
import process if there are any now
let's turn to the sequel way studio and
seaquest commander tools that are
designed for database scripts and
application script conversion purposes
to convert my scale to oracle with
sickle way studio all you need to do is
to provide the conversion direction
using the source and target options
after that you need to place the source
my scale code to the right pane on the
tool and run the conversion at the
bottom of the tool you can see the lock
of the conversion process that shows if
there are any errors during the script
conversion from my scale to oracle
database once the conversion has been
completed you can compare both source
and target script in one window side by
side for your convenience in the sequel
West commander there are also two games
that give you their protein to specify
the file or files or the whole directory
for the conversion so to convert from my
skill to oracle you just need to specify
the source and target from the list of
supported databases specify the files
for conversion and then click run when
you specify the directory for the
conversion you also need to provide a
template for the files that you would
like to convert from my scale to oracle
database and provide the target
directory for the conversion results
at the bottom there is generated
conversion log file with the information
about conversion issues if there are any
after the conversion by double clicking
the file in the source and in the target
pain
you can review the conversion results
side by side like in single way studio
that is all I wanted to tell you this
demo the information about the
peculiarities of mysql to oracle
migration and other tools that I supply
systems provides for database migration
support will be described in our next
channels or can be found on our website
i hope this demo was useful
thank you