[gentoo-user] Database migration software

[gentoo-user] Database migration software

[Jerônimo Backes]

[-- Attachment #1: Type: text/plain, Size: 483 bytes --]

Hi. I have a small database (100 tables) in firebird and want to migrate SOME data of it to a postgresql database. The latter database serves to a different purpose, so I just have to migrate specific columns of specific tables from the former database.

Is there any app that can do that job? If not, I think I should create one...

 __________________________________________________
Fale com seus amigos  de graça com o novo Yahoo! Messenger 
http://br.messenger.yahoo.com/ 

[-- Attachment #2: Type: text/html, Size: 498 bytes --]

Re: [gentoo-user] Database migration software

[kashani]

Jerônimo Backes wrote:
> Hi. I have a small database (100 tables) in firebird and want to migrate 
> SOME data of it to a postgresql database. The latter database serves to 
> a different purpose, so I just have to migrate specific columns of 
> specific tables from the former database.
> 
> Is there any app that can do that job? If not, I think I should create 
> one...

The easiest way is to use your favorite language and output CSV files of 
the data you want to import. Then take the files and import them into 
the new database. In Mysql it would look like this and I'd expect 
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
-- 
gentoo-user@gentoo.org mailing list