SQL Server (MSSQL) to MySQL Database Migration Demo

The demo is showing an example of how SQLWays can convert SQL Server (MSSQL) to MySQL database. http://www.ispirer.com/products/sql-s...

---

Closed Caption:

cool this is a demo on BART
sequel server to my ass kill conversion
using tools provided by I aspire systems
so on first wall
are I I would like to mention I spar
systems provide a set of tools
that helps you in nineteen in zia
database and application migration
processes
I'm so the data as well as
us he mar- and business logic
can be converted using sick always
tools and also aspire systems provide a
set of course
for comparions their data conversion
from one database to in our database
and for replication processes so
or on based on triggers okay so
first let me in start from sick always
resort
up this is a tool you can see on your
screen
first then restart it you see welcome to
seek Luis resort
Beach here you can entries a licensee
you half
picking provided by I aspire systems and
was also selected project director
creating new project option
was it lets you specify I am and
directory where all sit unions
for sickle ways tools at you provide for
this particular project
will be stored so all the data type
macon cited too far maintenance
okay City selected for conversion will
be released its hearings this project
file and options to do specified
will be stored in a special buying ifile
foresee call wasteful
onto this order to be speech
you need to specify as a ODBC DSN
foresee connection to a sequel Server
database
you can see I've got one predefined
already be citizen
or by clicking new you can specify your
own ODBC DSN
sick always wizard and also you need to
provide a username and password for a
sequel Server database
as it must have appropriate privileges
usually ZCR
DB rights in order to have an
opportunity to
make a Celtics from system tables from
sickle cell database
because sick always up
uses Aquarius to
system tables to extract additional
information balce
or text cities a converted converting
it is it's be it's converting from
sickles for database to buy
ask on which was a targeted to be speech
you need to specify
to my sequel as a target you can specify
the version
or overt my sick all database server
isles of course names a database names
the username and password
are quiet also if you are
of course several instances of my sequel
database
is thought on one host you need to
provide a port number four
my sequel server
you are going to use it isn't import
on that one speech you
can specify the bin directory for my
sequel exit to look Asian because
sick always uses native to all my sequel
boat exert all up to Lords a
optics and definitions into MySQL
database
hours or so to fortunes it helps you in
control in zip
data logging into MySQL exit
into my skill database so just if you
need some specific
well she sure to support you can wash
just to
send your request toss and we'll help
you
you to know I'm zip sick Luis resort on
Spotify database objects ok we re page
you can see at least those optics
provided forces for database
so each object is stored in its own
scheme or
are hope he and so on object-type
so you can reviews in and slept for a
conversion
use an arrow buttons or by just
dragged and dropped from left to right
pane you can see a set of object is
provided for
ours is conversion because I'm using the
project directory
so all specifications are already
the reused in zeese particular on
of sick always resort source said of
auctions that helps seen
tuning knobs immigration process like
our control and as a result for scan war
from are using replace resort warts
option or army
our options it I'll changes human name
conversion from me Microsoft sick also
wrote to MySQL database
also 0 options that help you in
controlling
well whether you would like to export
the data
or not export the data or whether you
you would like to exports a
us he mar- or no
also there is so other options that help
Syrian
change in za dated that may have been
was a global level like here
and on local level for specific table
I for specific columns in specific tapes
also you can change object names and so
on so forth so
this is for you actually can do in sick
always and
loss of all those things so just turned
to ass with your request request
regarding the particular feature you
would like to use in not too long
weekend
tell you hopeful I use it in all 20
for almost 25 expert file options
Beijing it justifies export directory
which will be used as a intermediate
repository for all the files it's a cool
ways we charging rates
school is to actually generates for
subsequent Lord into MySQL database
so this is a set up bitch scripts lordy
to
in file call months up text
file so is deter- sickle files
peace definitions of objects
so and also is so are me
set of files can be run using a sick
always old bitch file
is it is used for important all sorts
one by one
me to MySQL database so I've got
exploded aboard to hear
where specified and I'm using running
tree small auctions at
helps me in depicting is the source
commended in the same file ways its
equivalent for my sequel
database
certifying bird option speech as for my
sick all day to
MySQL database you can see there is a
block of two
major options here where you can make in
the import
on to local or more targeted base
from the local system this is a system
were sick always
recites so if you cover my ass SQL
client
installed on this computer so you can
use the sorption as
I use it I because I of my eye skill
exit tool installed here
or as there is another one option hours
that
states that import will be made on the
remote system so you can generate a set
of scripps
this can be windows-based files or UNIX
shell scripts
up which you can subsequently
a redirect to another day folder
on another computer and runs the import
process from
that location and you need to specify
director option in this case
as this is a directory I'll
owns a system on the remote system that
you will be using
as a are the reporter for all the false
for my ass kill we also use immigration
sequence for tables
as fast because in this case data is
loaded into MySQL database
before constraints and indexes and this
is a professor noble way of doing is a
on important a MySQL database actually
so this is a use this election speech
was some information about sir
migration course you're going to perform
enough
clicking Next we go to immigration
status pitch
so here at this point all talking next
to the store database
2m or Microsoft single server and
extracts
also objects one by one from store
database
and on converts this creates and the
data stored in zeese
and database
and store so this information in the
export directory
inappropriate for mark
so we
have you export pH and we can see is
that the father has been created so far
by alt wall
is a bitch file it contains sick 14
definitions loading into MySQL database
you can see it said
up tips call file is been lauded
you should likes this
you can see it here Anza are ditto
Lauren
is performed using the audio file weasel
or detain in file calment
there's a text file
always eat from nation's size it is used
for the delorean
and the older like almond books Lexus ok
are also
lets me go berserk
so I asked if I do you use need to
go back to the import
just like me region you read the import
process so you can see a shell scripts
were are created
is a specify the show location you can
use it you can see a shell scripts with
the same set of common sexually
how's that up in runs a
DD local monks with this group current
conversion
group loyalty to MySQL database services
sequel files was it the Lord into MySQL
database
and on common for it all day files
our Lord into MySQL database so are now
averaging rated them
you can see it here are four people so
the urgent need to set to false for
constraints as well
and in texas also I in the soap opera
two files
as for sport procedures triggers
functions others also on generated wont
come comment
as that a
lawlz tradition you shin alza
treat your or stored procedure I into
my so called it base and
other generate a single file always a
commented source in its a coolant for
MySQL database you can see it here okay
so all this is a set of scripps
the settle for file sorter generated for
my skill as a target database
also
up to mention major for a file so that
controls
the export process you can see the sick
always look for a while
was information looooove was a common
lines it is used
for do in the export Weezy information
%uh balls objects selected for
conversion statistics regarding
each object extraction from store
database
ends them the information book
confirmation of four issue object-type
home much data has been extracted using
in
sick always for tables home mean you're
also deter
a number for texts it where extracted
correctly
and the same 4oz ok types likes you
stored procedures functions triggers
but instead of the up data
data size it shows a number of lots of
court
for each what chick type
and then the overall statistics the
for the call database also do users
generate to secu is report
ish channel file the pixie information
in the more readable form art you can
seize it
I'll in summary page
objects summer information for the whole
database
this is a summary table for each ok trip
type:
total number for chips on number for
also data for tables
Lance of court for are business logic
objects
was as they were extracted Wiese issues
or
result issues for his issues and a
number of seconds
are me required for cities NZ on
ulcers the intercourse table for each
object-type work tables use stored
procedures
functions and triggers and some
information about putting too far
changes
in are different object that's in its
search for
modification sit where I used insides
their
database conversion and
s4 also we have export completed
knowledge star people process to the
target database for you can see
also objects are imported one by one me
to my sequel using Kalman
tools conlon tools can finish the
process
and we can use the import low provided
by
all company that actually contains
information that my sequel
a server returns to or Picatinny
to seek always regarding the status of
imports or user where any errors say
will have been depicted here
change the sick always on pilaf while as
for data import
generated to look file for each operon
over
are import process and you can see is
which ok I'll sequel
call months were sent to my ass kill
or database server and what was there
fact
I was there was a warning or I am
home in the roles were was exec where he
was a key or no
in this section you can see polls
information in local file provided for
each
I object lauded you do you do only into
MySQL database gay so all the objects
were loaded into MySQL
up now let's turn to sick always
commander and sick always Studio Tools
said are used by in all company
for Scripps contortion so s4c call the
studio first two-goal
on as this sir Tool Works we Swan
script at a time you can provide a large
scripps
from I Microsoft sickle-cell work
of was ill at you so separated
his goal statement for example as
usually my
Microsoft's a course full circle so a
pro it provides for
when generates I'm a script of the
database
so you can use it like this
and by specifying as source'.
like Microsoft single server and a
target like my ass kill
and clicking Ron you can convert
the source so aren't great procedure
statements or simple statements there
can be specified
a CREATE TABLE statements and other our
definitions of objects
that can be converted into ask reid for
my ass keel
exec one lone tall can see a delimiter
is
redefine here and Sam I also hope to
serbian lordy into
on my asking all tool as a wall street
my skill databases one script
an is as same window you can see the
source and it's a cool and provided by
I'll walk Omaha o'toole also
below you can see is a calm and that is
actually used force these
a conversion process because I'll is
for all the tools at a graphical tools
that all company products
they're used one tool called soco always
exist this is a common blunt tool
that can work with us databases using
ODBC connection or we scripps
use in a connection to a direct route so
you can specify director or
file and make a conversion of a script
database in a script from one database
to announce
actually so all company I recommend its
use in
ODBC connection because all totally
ditional extracts information from the
sordid to base
that helps in a mendini in business for
the conversion
more accurately
a for specific
think features the toll supports in
because everson matter said data types
for calm censorship
so all this information is used and Wild
Dunes immigration
what american commission process
okay so um also
are let me show you sick always
commander
well this tall oaks a over similar to
studio
I except for the left and right panels
r4 I'll big file specification actually
so you can specify
file or two files for conversion or you
can
are specified as a I'll whole directory
for conversion here
and Zen can run the conversion process
from
Microsoft us a call sir or
to a MySQL database so
icky workforce your weekend for example
let me speak to fight one source
all that specific fire Microsoft sickle
cell or as a source database
and the my ass kill
as a target database well as strong as a
conversion
so you can see it makes a conversion
from source
target use in a convert to air falters
accused it's a fight as a target for
you can change it here however you wish
like
example it can change it s rest one
and your honor runs when you're on the
conversion you can see a common line
tool is used to gain
or his conversion process you can go to
press one folder open
source it's a communal and provided
automatically
and reviews the conversion here
here's a source insurers it's a cool and
in MySQL database so
everything is quite simple as you can
see okay so
this is all information involves a
toolset
up I'll company as persistence Pro S
four min Canaan
database integration it's so the
comparison tools
was there X sick always
assessment resort and does
them replication course ok will be
described in
our other sessions thank you very much
for your attention
but