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 --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
