Re: Converting Microsoft SQL database to MySQL

- Original Message - > From: "Halász Sándor" > > noting that MySQL does not really support CSV: one can set all Not *entirely* accurate: MySQL does include a CSV engine that you can use in the same way you would use InnoDB or any other engine. If you create a table a with engine=CSV a

Re: Converting Microsoft SQL database to MySQL

I would appreciate the help if anyone could share what tools will you recommend of converting SQL database to MySQL. The Data Wizard for MySQL software by SQL Maestro Group includes a powerful Data Pump tool that can transfer schema and data from any DBMS to MySQL: http://www.sqlmaestro.com/pro

Re: Converting Microsoft SQL database to MySQL

2012/01/30 15:06 +0800, James I am involved in a project to migrate our entire database from Microsoft SQL to MySQL. I would appreciate the help if anyone could share what tools will you recommend of converting SQL database to MySQL. If it is SQL server, maybe dumping in charact

Re: Converting Microsoft SQL database to MySQL

Thanks Carl. I found a tool called Full Convert that did conversion (small database only) from MSSQL to MySQL. I tried to test their Trial version and it converts completely with similar structure, fields, etc.. Because it's trial version, some more than 5

Re: Converting Microsoft SQL database to MySQL

I do this quite frequently. In our case, we are converting competitors data so the process is to use Navicat (premium) to bring the data from MSSQL to MySQL (in the same fields, etc.) and then use a program to convert it into our format so it will run on our system. The only thing I have had t