From:       To:      

Home > Documentation > SQL Server to MySQL > Tutorial

Step 3 of 7. MySQL script file settings

Through this wizard page SQL Server to MySQL converter allows to specify how the resulting dump file should be formatted. There are following settings available:

  • MySQL version - determines the syntax of SQL statements. Old versions of MySQL (before 3.23.6) apply more restrictions on syntax of queries. 'Old' syntax is accepted by 'new' versions of MySQL but not vice versa. Use 'old' syntax if not sure about the version of MySQL.
  • Line breaks - specifies how to separate text lines in the dump file. 'MS Windows style' option means to use '\r\n', 'Unix style' means to use '\n' as end of line.
  • Add lock for write around 'INSERT' statements - makes import of the dump file into database much faster. To use this feature in MySQL 4.0 and higher it requires global LOCK TABLES privilege and SELECT privilege on the involved tables. In MySQL 3.23 and earlier you need to have SELECT, INSERT, DELETE and UPDATE privileges for the tables.

Other options are self-explained.

See Import MySQL dump files article to learn how to import script file to MySQL server. Have questions? Contact us