# how did you import a MySQL database?

I need to import a MySQL database but I can't.

##### Post Metadata
- Posted at: over 6 years ago
- Net upvotes: 2


## Comments
### Comment 1

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

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: Database Developer



### Comment 2

Try this: https://www.sqlshack.com/migrate-mysql-tables-sql-server-using-sql-server-migration-assistant-ssma-ssis/

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: President at Plaid Pony



### Comment 3

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/

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: IT Services




## Related Product
[Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews)

## Related Category
[Relational Databases](https://www.g2.com/categories/relational-databases)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4