Home > Documentation >
MS SQL 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.