Hello! i created the second unicode database, exported the ascii database, but get errors during the import regarding 'Referential integrity violated'. how can i avoid this issue? do i need to include a configuration to set the ordering of exporting/importing the tables so that no ref. int. violation occur? thx export db catalog outstream '/tmp/db_ascii.catalog' data outstream '/tmp/db_ascii.data' records // * // M LOAD TRANSFORMATIONPACKAGE x'0100000052501F46F67C00007E30990C0501C0A8FFFFFFFF' // * // M EXECUTE PACKAGE TO TRANSFORM CATALOG // * // M Number of tables to transform: 49 // * // M Number of views to transform: 0 // * // M Number of synonyms to transform: 0 // * // M Number of tables transformed : 49 // * // M Number of views transformed : 0 // * // M Number of synonyms transformed : 0 // * // M EXECUTE PACKAGE TO TRANSFORM DATA // * // M Number of tables to transform: 49 // * // M Number of tables transformed : 49 // * // M UNLOAD TRANSFORMATIONPACKAGE x'0100000052501F46F67C00007E30990C0501C0A8FFFFFFFF' // *
and imported it to the unicode database with: import db catalog instream '/tmp/db_ascii.catalog' data instream '/tmp/db_ascii.data' records // * // M EXECUTE PACKAGE TO TRANSFORM CATALOG // * // M LOAD TRANSFORMATIONPACKAGE x'01000000C6511F46367D0000610770750501C0A8FFFFFFFF' // * // M Number of tables transformed : 49 // * // M Number of views transformed : 0 // * // M Number of synonyms transformed : 0 // * // M EXECUTE PACKAGE TO TRANSFORM DATA // * // M Number of tables to transform: 49 // * // E -25010: SQL error -4005 = Unknown column name:(null) (error position: 34) // M Error at record 1 in infile for table ORDERDOCS. // E -25010: SQL error 350 = Referential integrity violated:FK_ORDERDOCS_ORDER,DB,ORDERDOCS (error position: 1) // E -25500: Errors processing command exceed maximum number of errors to ignore; processing stopped Mit freundlichen Grüßen / Kind regards, Chris Jölly Unycom Information Technology Services GmbH Solutions for Intellectual Property Management Tel.: +43-316-818 818-30 -----Ursprüngliche Nachricht----- Von: David Krcek [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 12. April 2007 15:34 An: Chris Jölly Cc: [EMAIL PROTECTED] Betreff: Re: Database migration from ASCII to UNICODE Hello Chris, yes, thats should work, please notice that you have to export the database in RECORD format. Bye David ========================= Id Konsil GmbH David Krcek Fon: +49 8233 73 69 23 Fax: +49 8233 73 69 24 Mob: +49 151 12 01 60 60 E-Mail: [EMAIL PROTECTED] Geschäftsführer: Ingrid Schwarz, David Krcek Sitz: Sommerstr. 7, 86415 Mering Registergericht: Amtsgericht Augsburg Registernummer: HRB 21669 ========================= Am 12.04.2007 um 14:31 schrieb Chris Jölly: Hello! we have a database created with UNICODE=no and DEFAULT_CODE=ASCII and want to migrate to an UNICODE database as we want to enable our application for utf-8 usage. Can that be done with creating a new db instance, export the old db with loadercli and imported to the new db instance? thx Mit freundlichen Grüßen / Kind regards, ________________________________ Chris Jölly Unycom Information Technology Services GmbH Solutions for Intellectual Property Management Schmiedlstrasse 1 / III, 8042 Graz / Austria Tel.: +43-316-818 828-30 Fax: +43-316-818 818-38 E-Mail: [EMAIL PROTECTED] Web: <blocked::http://www.unycom.com/> www.unycom.com Firmenbuch Nr: FN 203321b / LG Graz UID Nr.: ATU 50837803 ________________________________
