How to convert MYSQL database into MSSQL database

Sometimes we need to change our whole database into another database. Here I am going to show you how you can change the MYSQL database into MSSQL database in one click.

Download MYSQL to MSSQL Converter:
https://code.google.com/p/mysql-to-ms...

---

Closed Caption:

hello event today I'm going to show you
how to convert a mysql database into ms
SQL database or if you have a script of
mice qualities then how can i convert
this scripting to MSS grid database
order ms SQL script so before i start
converting that abuse we have to install
MS SQL database in mice mysql database
in our system or if you have both the
both the database on our supported less
threatening
no problem so I have a damn server which
have PHP myadmin mysql database so here
it is
ok any so this is my jam server and this
is my PHP myadmin mysql database
ok and i have also ms s squared around
twelves little bit server in my local
officer local system this is my ms SQL
database server not for I need a third
party tool to convert these my scale to
msn square or I have a script of mysql
database so first of all we create a
database and apply this script contact
database on nice clothes to be said
about ok
so first of all i'm going to create a
database on in my ms mysql database
server so i created it did his test it
up and create
so this is my database test data and now
i'm going to execute the whole script of
x squared script to create the tables
and entries in that particular database
ok
okay so this is my whole script which
have two tables and entries now it on go
to execute ok executed
now i have three tables in a database
and stable have 7600 injuries and the
second table is three for three entries
and activities and three-eighths few
entries here so now we need to convert
this data is is waiting to ms SQL
database so before doing conversion we
need a odbc connector of my screen
because we need a converter which is a
third party tool and that tool requires
the odbc convert a connector of the
mysql
so you can download the odbc connector
from the Oracle Oracle the plates and
then from the google also so I'm going
to install this is my scale connector
odbc 5.1 so i have already installed the
odbc connector so I'm going to cancel it
to a tree have to install it so and just
click on finish after installing the
order is electrical to the control panel
to access the odbc connector and then
administrative administrative tools here
you get the ODBC data connector 64
written a little bit so i have a 64-bit
operating system so ax around that 64
bit of motivation connector so i have
already the connection so i am going to
delete it and create a new ok so just
select the word 5.1 odbc director
the next keep a name any name i'm going
to give the test data and get the
location of the server i have a local
loss if you were have the remote
location on any IP location then you
include get the that particular IP here
select your database which you want to
convert so this is a test
ok and now you need a third party tool
to convert mysql database to ms SQL so
you can download this tool from the
description i mention link offer google
developer pages where you can download
the stool freely so just go to the
district description and downward stool
and after download and start to the inch
file and open it
ok now double-click on the mysql to SMS
great converter this tool to convert
your whole area is nice latest to ms SQL
database so first of all I have to
connect up board is here so first of all
I have created my scale MSS we're sorry
mr. database after then my syllabus so
first of all I have to give a server
name or a beer myself adjustable myself
out on that look at all so I can't wait
here . or at the local lost
if your server on the particular IP then
you have to provide here a particular IP
after then you can use several
indication or Windows application so i
used up into the tradition and then
correct ok so I successfully connected
by ms SQL database and now i can I have
to create a database in my ms SQL so
from my school database and get out my
school data can be easily computed into
particular database in ms square so I
created a database here select ok so
this is my database or blanket of this
continues here and I select database
from the drop-down and that you have to
create the database
ok no the last entries
ok now i have to connect my my school
and it is so once again I have to give a
server name so once again I have a local
host my skills that were that if you
have a one particular IP then give the
IP username or password they have no
password authentication so just click on
connect ok successfully no select the
database which you want to convert in ms
square
ok.now click on start button and yes
let's take a few minutes our hearts
maybe depends on your data scale how
long your database is so okay this is an
error here determination error to
foreign keys are not converted from my
school 2m is correct because of my mysql
database is not properly to find a
little script of my my school server
which we used to create a myschool
databases not correctly defined properly
defined so this is the error for foreign
keys but our database of mysql converted
into ms SQL properly and the whole data
of mysql server copied into msn swear so
let's see the database off ms grip so
here is the tables are ok i got the
tables to these countries and the
reasons
ok so i'm going to select all those 1000
was costly so ok here is the data i
created the blanket is here but now i
have a few rules here
okay let's see here is 760 rules in the
country city and the country table and
here is also 760 little so all get out
of the country table successfully
compete so I open this video will help
you to convert your mis well database
into ms SQL database so thank you thank
you for watching my videos subscribe me
and I take care