Re: [GENERAL] migrating from informix
--- Gregory S. Williamson [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] migrating from informix
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 the tables and supporting SQL (perl scripts mostly) transferred cleanly; I didn't try to automate conversion of stored procedures or triggers (not a lot of these in our runtime). Greg Williamson DBA GlobeXplorer LLC -Original Message- From: Jaime Casanova [mailto:[EMAIL PROTECTED] Sent: Monday, December 06, 2004 9:32 PM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] migrating from informix
--- Gregory S. Williamson [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly