Re: MySQL-kind CSV; Converting Microsoft SQL database to MySQL

;>>> 2012/01/31 10:52 +0100, Johan De Meersman 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 and then go look at the data dictionary, you'll find the files a.frm and

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

/products/mysql/datawizard/ Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com - Original Message - From: "James" To: Sent: Monday, January 30, 2012 12:06 PM Subject: Converting Microsoft SQL database to MySQL Hi All, I am involved in a project to migrate

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

Converting Microsoft SQL database to MySQL

Hi All, 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. Cheers. James