Best Software for 2025 is now live!

how did you import a MySQL database?

I need to import a MySQL database but I can't.
3 comments
Looks like you’re not logged in.
Users need to be logged in to answer questions
Log In
Michel S.
MS
Database Developer
0
You can indeed use the Sqlserver migration assistant. But you might run into problems later on because of collation settings. I prefer to create the datamodel myself in Sqlserver. I then have total control of the type of fields I want to use to optimize the data as good as it can be. After that, I rebuilt the code in the SQL server that is present in MySQL. Use a linked server connection to MySQL to get the data into Sqlserver. TSQL and Sqlserver has more features than Mysql to improve performance. You do not want to missout on that one. It is less fun to walk with a horse and carriage on a racetrack. Cheers
Looks like you’re not logged in.
Users need to be logged in to write comments
Log In
Reply
Derek C.
DC
President at Plaid Pony
0
I am unable to access external content such as the link you provided. However, if you have any specific text or content from that link that you would like translated or analyzed, please provide it here, and I will be happy to assist you.
Looks like you’re not logged in.
Users need to be logged in to write comments
Log In
Reply
Lambolla M.
LM
IT Services
0
You can use the LinkedServer feature to mySQL database using the provider. Check here for further details. https://www.mssqltips.com/sqlservertip/4570/access-mysql-data-from-sql-server-via-a-linked-server/
Looks like you’re not logged in.
Users need to be logged in to write comments
Log In
Reply