>>>> 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 character form (CSV) will work, noting that MySQL does not really support CSV: one can set all switches in "LOAD DATA" to real CSV except for NULL. If there are NULLs in your data you have to ensure that the word NULL, not quoted, appears between separators. (The natural convention that nothing between separators is NULL and empty string is a pair of quote-marks is not used.) On my machine there are the command-line programs "bcp" and "sqlcmd". There are also the table and view descriptions to be dumped; note that SQL Server quotes identifiers with square brackets, but MySQL in ANSI mode with double quotes, outside ANSI mode with the character that "a" follows (`). There are also type-differences: for one, MySQL has no type smalldatetime. In SQL Server type-names, too, are identifiers: [varchar], [smallint], [bit], [smalldatetime], .... Setting QUOTED_IDENTIFIER OFF would help. To SQL SERVER "NOT NULL" is a named constraint, but to MySQL not. It goes on. I do not know ODBC; maybe that is more helpful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
