Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: migrating from informix

Re: migrating from informix

From
Jaime Casanova
Date:
--- "Gregory S. Williamson" <gsw@globexplorer.com>
escribió:
> Jaime --
> >
> > Sorry that I didn't respond earler -- been quite
> > busy.
>
don't worry.
>
> >
> > We have migrated our runtime aspect (which is
> heavy
> > use of the Spatial Blade/postGIS in a mostly
> > read-only environment); we were using Informix 9.3
> > dynamic server.
> >
> > I have some notes I wrote up that I'll post
> tonight
>
that will be of help
>
> > -- they are on a machine I don't have access to
> > right now. Most of the tables and supporting SQL
> > (perl scripts mostly) transferred cleanly;
>
i'm doing that at hand right now.
>
> > I didn't
> > try to automate conversion of stored procedures or
> > triggers (not a lot of these in our runtime).
>
i have no one.
>
> >
> > Greg Williamson
> > DBA
> > GlobeXplorer LLC
> >
>
thanx, greg for your answer

regards,
Jaime Casanova


_________________________________________________________
> Do You Yahoo!?
> Información de Estados Unidos y América Latina, en
> Yahoo! Noticias.
> Visítanos en http://noticias.espanol.yahoo.com
>

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

Re: migrating from informix

From
Jaime Casanova
Date:
 --- "Gregory S. Williamson" <gsw@globexplorer.com>
escribió:
> Jaime --
>
> Sorry that I didn't respond earler -- been quite
> busy.

don't worry.

>
> We have migrated our runtime aspect (which is heavy
> use of the Spatial Blade/postGIS in a mostly
> read-only environment); we were using Informix 9.3
> dynamic server.
>
> I have some notes I wrote up that I'll post tonight

that will be of help

> -- they are on a machine I don't have access to
> right now. Most of the tables and supporting SQL
> (perl scripts mostly) transferred cleanly;

i'm doing that at hand right now.

> I didn't
> try to automate conversion of stored procedures or
> triggers (not a lot of these in our runtime).

i have no one.

>
> Greg Williamson
> DBA
> GlobeXplorer LLC
>

thanx, greg for your answer

regards,
Jaime Casanova

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

Re: migrating from informix

From
"Gregory S. Williamson"
Date:
Jaime --

Sorry that I didn't respond earler -- been quite busy.

We have migrated our runtime aspect (which is heavy use of the Spatial Blade/postGIS in a mostly read-only
environment);we were using Informix 9.3 dynamic server. 

I have some notes I wrote up that I'll post tonight -- they are on a machine I don't have access to right now. Most of
thetables and supporting SQL (perl scripts mostly) transferred cleanly; I didn't try to automate conversion of stored
proceduresor triggers (not a lot of these in our runtime). 

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From: Jaime Casanova [mailto:systemguards@yahoo.com]
Sent: Monday, December 06, 2004 9:32 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] migrating from informix


Hi,

someone has successfully migrated a database from
informix to postgresql?

there are any tools that helps or maybe an script?

regards,
Jaime Casanova

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly