Re: [SQL] Re: Informix->PostgreSQL database convertion

[rmcm]

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 able to create a file of SQL statements like when using postgresql's
 > command  "pg_dump -f outputfile mydb"
 > 
 > 
 > 
 > ---(end of broadcast)---
 > TIP 6: Have you searched our list archives?
 > 
 > http://www.postgresql.org/search.mpl

-- 
Rex McMaster

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[SQL] 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"



---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

[SQL] Re: Informix->PostgreSQL database convertion

[Sylte]

It is convertion of the data, not the application...



---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[SQL] 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" <[EMAIL PROTECTED]> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
9d8r7v$1to$[EMAIL PROTECTED]">news:9d8r7v$1to$[EMAIL PROTECTED]...
> 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
>
>



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]