How to Migrate MySql database to Sql Server "EASY"

[@dmueller78]

This guide helped me a lot. For anyone searching in 2024, the video showed him use an older MySQL ODBC driver than 9.1 which is out right now. I could not get a connection from SSMA to a local MySQL using 9.1. I switched it to 8.0 and it worked perfectly. This video was also very helpful walking through the process of migrating the data and saved me a lot of time.

[@AbeL-mp3cq]

i migrate from mysql to sql server 2012, right now, it's 09-08-2022, still working, ty Shakir

[@islamicworld8061]

You are legend bro. Well explain in short time with quite easy steps .

[@astatine0085]

what about migrating into sql server express 2019? the free version doesn't have the connection features needed from what I read.

[@dwainbeckford1]

Worked for me but I used the SSMA for MySQL not for Access. Any reason why the used the SSMA for Microsoft Access in this video? Seems you indeed used the SSMA for MySQL as after you opened it on the desktop it said for MySQL.

[@vijayfulwar6172]

Will it be good for blob data type fields.

[@ucretsiztakipci6612]

Great, helped me to migrate 15.8 million rows.

[@fahadsulaiman6451]

which collation need to use when migrating arabic content from mysql to mssql

[@ezequielgustavomunoz1441]

thank you very much brother! I send to you good wishes from Argentina!

[@ShakirAlimit]

I really appreciate it if you subscribe to my channel.

[@ezequielgustavomunoz1441]

@@ShakirAlimit yes brother, ;)

[@clementsebastian5258]

Thumbs up for the post. I never thought if I could make it.

[@zameer.vighio]

Great work, Keep it up.... 👍

[@fahadsulaiman6451]

In mssql, show prefix in the table after migration. for example business.adjusment in your table. how to remove (business) while migrating.

[@dipjoytidebnath5530]

how to data migrate.in your process only schema are migrated soi please explain how migrated data and schema both

[@christianlugatiman9226]

Thanks! You saved my 1 million+ data :)

[@ShakirAlimit]

thanks and don't forget to subscribe my channel.

[@erfanazkat2133]

i love you you saved my life you are my hero

[@gopalt1848]

@Shakir Ali Hi , I want to migrate data without down time. So if i start MigrateData at 10 AM and it may take 1hr to complete. Now , if the source DB got some other events like insert,update or delete then how to do we migrate only those particular changes? If we use Migrate Data option again for 2nd time, then it will migrate whole Table data or only those particular changes? Do we have any options to automate this process?

[@sergiovalp]

thank you, ¿is possible avoid the database name for each table that is migrated in the target sqlserver? I mean "category" instead "business.category"?

[@PBmcclain]

by any chance have you figured out how to do what you were asking?

[@PBmcclain]

just fyi i forgot how sql saved. you have to save into a schema. So the best bet is to change the default under modify before conversation to 'dbo'

[@muzammelhaquemukul7089]

Great video. What if there is any reference between two table in MySQL like primary & foreign key in SQL Server. Does it keep, convert them and migrate them to SQL Server as is or have to do something else afterwards.

[@ShakirAlimit]

Yes it will take care about it.

[@muzammelhaquemukul7089]

@@ShakirAlimit Thanks for the reply. Greatly appreciated.

[@jamols09]

I cannot find Connect To Mysql server. Only showing up Connect to Sql server, Find Databases & Add Databases

[@gopalt1848]

Thanks for video. if we use again MigrateData option after some then it will migrate all records or only new records which are inserted in meantime. any idea?

[@ShakirAlimit]

Not getting your point sir

[@gopalt1848]

​@@ShakirAlimit Hi , I want to migrate data without down time. So if i start MigrateData at 10 AM and it may take 1hr to complete. Now , if the source DB got some other events like insert,update or delete then how to do we migrate only those particular changes? If we use Migrate Data option again, then it will migrate whole Table data or only those particular changes? Do we have any options to automate this process?

[@andreiputivet5126]

I was helpful, thanks. Change second link in description: www.microsoft.com/en-us/download/confirmation.aspx?id=54257

[@eula1194]

Make a vid on how to connect to both at the same time and fetch data from both

[@hugomancera117]

Thanks for the video, it helps me out a lot!! now that I have migrated my tables my question comes this way: How can I keep my data sync / up-to-date, do I need to keep doing this or is there another way? please help me out with another video or links on how to do this.. I appreciate your help. Thx.

[@ShakirAlimit]

I am not sure this will lost your data. But you can do few things you create a script to insert old data and after migration you can run that script, this will update your tables.

[@chethanprasad4944]

Thank you for the video 🙂

[@umairnawazdeputyassistantd6126]

So much helping video ...Thx bro keep it up Jazakallah

[@ShakirAlimit]

Thank you!

[@Jikpuk]

thanks for the video. you helped me a lot🙏

[@gurdialmanj]

system error 126 myodbc8w.dll error copied the file to desired location but error still persist

[@Luziuh]

somos cinco pibes y nos salvaste el proyecto a todos

[@ShakirAlimit]

Can you speak English

[@jamols09]

But I cant find my database server in the list

[@mahenpriy]

nice one thanks a lot....

[@mohamedabogabal84]

Can I use This tool to mingrate from Sql Server to mysql database?

[@miloraddjurdjic1695]

since I don't see any response and i know I am about 6 months late but you can use mysql workbench to do migration, it works perfectly.

[@oleoni1437]

that was awesome, this method is working perfectly fine, thanks a million.

[@elga0311]

Excellent, great video. You helped me a lot.

[@ShakirAlimit]

Thank you

[@shahg5864]

Nice lecture

[@ariffkmy4235]

Thank you very much brother! You saved my day!

[@rakeshverma5099]

Good Bro

[@hansdebruijn2821]

Thank you very much! That helped me a lot.

[@PBmcclain]

Great video! Thanks for producing this!

[@hugoquezada6421]

You are grate!! Thank u man!

[@mahfuzurrahman4860]

Great! It's worked, thanks.

[@limsocheat]

Thanks You. It works perfect.

[@vanzettydurant]

exc elent -thank for your help

[@sonvu-cg9fd]

Good job.. Thank you!

[@nicolelau917]

Dang it. I was following the video and wondering why SSMA looked different for me than in the video. He said to get Microsoft SQL Server Migration Assistant v7.8 for ACCESS. It's really Microsoft SQL Server Migration Assistant for MYSQL *cries** It's fine. Everything's fine T0T

[@TechandArt]

Plz have a watch on Tech & Art

[@Yaseen176]

wrong information provide you. Access link but show mysql

[@MrBuzerguy]

Thank you Shakir Ali!

[@ShakirAlimit]

Yes you can...

[@LuigiEnTwitch]

YES YOU KNOW THAT I KNOW THAT YOU KNOW THAT I CAN

[@ezmooj]

Awesome

[@hptimef4]

Thank you so much.

[@renklidunyamz5758]

man is king! thanks

[@AshwinKumar-yb1dl]

Thank you...!

[@ujnplay]

thanks a lot :)

[@ShakirAlimit]

@Eugene Thanks for watching my tutorials. Don't forget to subscribe my channel. :)

[@sinano.726]

Thanks!

[@hamzaessaadi7569]

thank youu !!

[@fahadsulaiman6451]

ARABIC CONTENT not migrating..

[@MiguelEspinozaThreeScrews]

Good!

[@AbeL-mp3cq]

TE AMO WN TE AMO

[@quvntvn]

#BtsSio