
6 Mar
2012
6 Mar
'12
2:09 p.m.
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 (http://ben90.com/2011/06/import-bcp-output-file-into-mysql-database/) 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? 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) Thanks, Hugh