Обсуждение: Re: Informix->PostgreSQL database convertion

Поиск
Список
Период
Сортировка

Re: Informix->PostgreSQL database convertion

От
"Sergey E. Volkov"
Дата:
I think this isn't so difficult.

Use "unload to ..." on Informix side ( from dbaccess ) and "copy ... from
..." om Postgres side.

"Sylte" <Sylte_@hotmail.com> �������/�������� � �������� ���������:
news:9d8r7v$1to$1@sunsite.dk...
> Howto? Are there tools or is it just a lot of hard work with a lot of PHP?
> Some examples or site-links will be appreciated :O)
>
> Thanks
> - Sylte
>
>




Re: Informix->PostgreSQL database convertion

От
"Sylte"
Дата:
How is the SQL command UNLOAD (informix) used to extract both data and
database architecture?

Is it able to create a file of SQL statements like when using postgresql's
command  "pg_dump -f outputfile mydb"




Re: Re: Informix->PostgreSQL database convertion

От
rmcm@compsoft.com.au
Дата:
is there an informix utility called dbschema which does this?
  dbschema -t all -d databasename > schema.sql

Sylte writes:> How is the SQL command UNLOAD (informix) used to extract both data and> database architecture?> > Is it
ableto create a file of SQL statements like when using postgresql's> command  "pg_dump -f outputfile mydb"> > > >
---------------------------(endof broadcast)---------------------------> TIP 6: Have you searched our list archives?> >
http://www.postgresql.org/search.mpl

-- 
Rex McMaster