Hi Hugh, we have a migration script prototype available at OTRS, that can migrate OTRS systems from one RDBMS to another. Please contact sales@otrs.com if you are interested. Regards, mg Am 06.03.12 15:09, schrieb Hugh Kelley:
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
-- Martin Gruner Senior Developer R&D OTRS AG Europaring 4 94315 Straubing T: +49 (0)6172 681988 0 F: +49 (0)9421 56818 18 I: www.otrs.com/ Geschäftssitz: Bad Homburg, Amtsgericht: Bad Homburg, HRB 10751, USt-Nr.: DE256610065 Aufsichtsratsvorsitzender: Burchard Steinbild, Vorstand: André Mindermann (Vorsitzender), Christopher Kuhn Verbinden wir uns! OTRS 3.1 schafft einfachere Integration mit Drittapplikationen – Für Frühbucher zum Vorzugspreis: http://www.otrs.com/index.php?id=2361&L=1