From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.62) (envelope-from ) id 1H2y4I-0006E1-C8 for garchives@archives.gentoo.org; Fri, 05 Jan 2007 23:01:46 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.8/8.13.8) with SMTP id l05MxNo2013301; Fri, 5 Jan 2007 22:59:23 GMT Received: from popmail.jettissystems.com (popmail.jettissystems.com [38.118.146.212]) by robin.gentoo.org (8.13.8/8.13.8) with ESMTP id l05Mv1uT009230 for ; Fri, 5 Jan 2007 22:57:02 GMT Received: from [10.23.0.139] (unknown [74.93.11.97]) by popmail.jettissystems.com (Postfix) with ESMTP id 02FB956D492 for ; Fri, 5 Jan 2007 14:57:00 -0800 (PST) Message-ID: <459ED7BC.7070107@badapple.net> Date: Fri, 05 Jan 2007 14:57:00 -0800 From: kashani User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] Database migration software References: <975001.59324.qm@web35614.mail.mud.yahoo.com> In-Reply-To: <975001.59324.qm@web35614.mail.mud.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable X-MIME-Autoconverted: from 8bit to quoted-printable by robin.gentoo.org id l05MxNoV013301 X-Archives-Salt: 73b28954-b685-449f-8460-989869f910e5 X-Archives-Hash: 4f9e324eb6195ce23516807e035cc5df Jer=F4nimo Backes wrote: > Hi. I have a small database (100 tables) in firebird and want to migrat= e=20 > SOME data of it to a postgresql database. The latter database serves to= =20 > a different purpose, so I just have to migrate specific columns of=20 > specific tables from the former database. >=20 > Is there any app that can do that job? If not, I think I should create=20 > one... The easiest way is to use your favorite language and output CSV files of=20 the data you want to import. Then take the files and import them into=20 the new database. In Mysql it would look like this and I'd expect=20 postgres to have similar tools. mysql -u root -p LOAD DATA LOCAL INFILE '/firbird.csv' INTO TABLE new_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (column_name1, column_name2, column_name3); kashani --=20 gentoo-user@gentoo.org mailing list