Hi Hugh, we have a migration script prototype available at OTRS, that can migrate OTRS systems from one RDBMS to another. Please contact sa...@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 --------------------------------------------------------------------- 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
