From: Chris Jölly (chris.joellyunycom.com)
Date: Fri Apr 13 2007 - 05:11:09 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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:david.krcekidkonsil.de]
Gesendet: Donnerstag, 12. April 2007 15:34
An: Chris Jölly
Cc: maxdblists.mysql.com
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: david.krcekidkonsil.de

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: chris.joellyunycom.com
Web: <blocked::http://www.unycom.com/> www.unycom.com

Firmenbuch Nr: FN 203321b / LG Graz

UID Nr.: ATU 50837803
________________________________

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]