Python script for converting MySQL dump into MSSQL compatible scripts Based on my project, I know the following points need to be converted 1. ` need to be removed 2. ENGINE=InnoDB etc need to be removed 3. int(size), (size) is not supported, need to be removed. 4. AUTO_INCREMENT need to be changed to IDENTITY(1,1) 5. UNSIGNED need to be removed 6. \n in text/varchar need to be changed to CHAR(13)+CHAR(10) 7. SET SQL_MODE need to be removed 8. SET time_zone need to be removed 9. If AUTO_INCREMENT is used, need to SET IDENTITY_INSERT ON before inserting records into the table. Then set it to OFF after insersion. 10. tinyint need to be changed into int 11. Remove 'IF NOT EXISTS' samedi 9 novembre 2013 à 09:48 Slobberbone, le 09/11/2013 à 09:48 Python script for converting MySQL dump into MSSQL(Permalink)