Return-Path: Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org Received: (qmail 22745 invoked from network); 30 Oct 2007 11:33:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 30 Oct 2007 11:33:19 -0000 Received: (qmail 28830 invoked by uid 500); 30 Oct 2007 11:33:06 -0000 Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org Received: (qmail 28815 invoked by uid 500); 30 Oct 2007 11:33:06 -0000 Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-user@db.apache.org Delivered-To: mailing list ddlutils-user@db.apache.org Received: (qmail 28804 invoked by uid 99); 30 Oct 2007 11:33:06 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Oct 2007 04:33:06 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [66.163.178.161] (HELO web34412.mail.mud.yahoo.com) (66.163.178.161) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 30 Oct 2007 11:33:20 +0000 Received: (qmail 95966 invoked by uid 60001); 30 Oct 2007 11:32:47 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=IlxNg6MRzsC2L7tYPXWQ6PKS6StmrAIUDzF53gSuZ3DpzhHSXUBFzb1iCbB9ufF2fuFcJIbjqX41/no/BRfXPjl6f6QOJa7m3bk7XQ+Wu7pGM0+3Q/NpRLjLgbyCb7yfZ3sNjpW/GPTuQbFy3W4r2elTvg5yaF56OXWLyIbfLTE=; X-YMail-OSG: AQqV45MVM1lli3AtUVCOczmqrJsjdw94rA53haLOOnj.b8XIQycmWEedHjC0ZII7My5PIf2sawgl7x5dR_kcOoQnnp3GAE1scuGe44aRlq5rkHZC7ZZsaTULdqff8mZGgeGLqA-- Received: from [82.122.69.161] by web34412.mail.mud.yahoo.com via HTTP; Tue, 30 Oct 2007 04:32:47 PDT X-Mailer: YahooMailRC/814.06 YahooMailWebService/0.7.134.12 Date: Tue, 30 Oct 2007 04:32:47 -0700 (PDT) From: Laurent ROCHE Subject: Advices for XML data file transformation To: ddlutils-user@db.apache.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1599160783-1193743967=:95421" Message-ID: <236009.95421.qm@web34412.mail.mud.yahoo.com> X-Virus-Checked: Checked by ClamAV on apache.org --0-1599160783-1193743967=:95421 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi All,=0A=0AI am a complete novice to XML (I have used it and understand i= f but I have never programmed anything with it).=0A=0AI am now in the case = where I am doing an export of data (using ddl-utils) from database A and I = need to import the data into database B.=0AHowever, tables in database A ha= ve extra columns (the last 3, identical in all tables) that are not present= in database B.=0A=0AHow do I achieve this ?=0A=0ACan DdlUtils do that on i= ts own ? (Can I export data without the last 3 columns, that will be the be= st option as the files generated will be smaller)=0ADo I need to modify the= XML file generated with a (Java) program ?=0A=0ALet me know your thoughts = !=0AAny help appreciated.=0A=0A =0ACheers,=0AL@u=0AThe Computing Froggy=0A= =0A=0A=0A=0A _________________________________________________________= ____________________ =0ANe gardez plus qu'une seule adresse mail ! Copiez v= os mails vers Yahoo! Mail --0-1599160783-1193743967=:95421--