Convert / Migrate MSSQL to MySQL - lessons learned ?

[hughkelley]

Has anybody done an OTRS migration from Microsoft SQL Server to MySQL?

Sketching this out on paper I plan to dump the data from SQL Server
using BCP. I believe I can then import it into MySQL using "LOAD
DATA LOCAL INFILE" commands
([url]http://ben90.com/2011/06/import-bcp-out ... -database/[/url])

Is there a specific table sequence I should use? Is there a way to
specify the column names in the input files so that I don't need to
use this highly-descriptive syntax for every single table? Is there
a better tool/way altogether?

[code]
LOAD DATA LOCAL INFILE 'BCP_FILE' INTO TABLE TABLE_NAME
FIELDS TERMINATED BY '@**@'
LINES TERMINATED BY '*@@*'
(TABLE_FIELD_1, TABLE_FIELD_2, TABLE_FIELD_N)[/code]

Thanks,
Hugh

[ferrosti]

This is a good way to go on a low level migration base. In case you are familiar with it, get ready to go.
Rather than looking here, I´d recommend to have a look at mySQLs migration guide. There are plenty of hints on how to migrate from MSSQL.