Re: Postgresql To Oracle9i

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Postgresql To Oracle9i
Дата
Msg-id 3E4156CF.DEF6878B@Yahoo.com
обсуждение исходный текст
Ответ на Postgresql To Oracle9i  ("Atul Pedgaonkar" <atul@imcindia.net>)
Список pgsql-sql
Atul Pedgaonkar wrote:
> 
> Hello,
> 
>         Atul here From india.Anyone who knows how to mirgrate the data from
> postgresql7.2 to Oracle9i.Please give the idea or methood to transfer the
> data.

Use pg_dump to create separate schema and data (as INSERT statements)
dumps. Edit the schema so that Oracle is happy with it and run the two
SQL scripts.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


В списке pgsql-sql по дате отправления:

Предыдущее
От: george young
Дата:
Сообщение: design question: status table+log table, indexes, triggers
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: automatic time/user stamp - rule or trigger?