0

i have a SQL server database which has normal data types..Not even blobs..

Now i want to convert it to MySQL database.

What would be the best way to do this? Any good open source?

Thanks.

New contributor
Odata Dev is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • Do it "by hands". Generate DDL scripts for SQL Server database as text file. Edit it, divide on 2 parts - clear structure, and indices/references/etc. Import 1st part into MySQL. Export data from SQL server tables to CSV file and load it into tables. Import 2nd DDL part. Yes, it is long way, but you may be sure that none strange problem occures. – Akina Mar 25 at 7:33
  • Is there any open source or free tool which does this? – Odata Dev Mar 25 at 9:04
  • Workbench - Migration. dev.mysql.com/doc/workbench/en/wb-migration-database-mssql.html – Akina Mar 25 at 9:17
  • Thank you and that's what i need.. – Odata Dev Mar 25 at 9:35
  • We can close this..Just add an answer and i will accept it and we can close this – Odata Dev Mar 25 at 9:36