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
