Hi !. I need info about cases or tools of migrating Infomix to PostgreSQL.

Any info will very very important .

Thanks !!

sending to informix-list

"Victor Dario Martinez" <dmartinez@siu.edu.ar> wrote in message
news:cjhie1$da6$1@news.xmission.com...
>
> Hi !. I need info about cases or tools of migrating Infomix to PostgreSQL.
>
> Any info will very very important .
>
> Thanks !!
>
> sending to informix-list

http://www.jobcentreplus.gov.uk

Victor Dario Martinez wrote:

>
> Hi !. I need info about cases or tools of migrating Infomix to PostgreSQL.
>
> Any info will very very important .
>
> Thanks !!

http://dir.yahoo.com/Regional/Countr...ss_and_Economy
Shopping_and_Services/Employment/

--
Strewth! Stick a sock in it, Sheila!

Victor Dario Martinez wrote:

>Hi !. I need info about cases or tools of migrating Infomix to PostgreSQL.
>
>Any info will very very important .
>
>Thanks !!
>
>sending to informix-list
>
>
Hi,
we are evaluating going from SE to Postgres. So far the biggest
gotcha was having to use transactions, and the biggest gotcha with that
was commiting work to the database closes all open cursors.

How complicated are your database needs?

--
Scott Burns
Mirrabooka Systems

Tel +61 7 3857 7899
Fax +61 7 3857 1368

Scott Burns wrote:

> Victor Dario Martinez wrote:
>
>>Hi !. I need info about cases or tools of migrating Infomix to PostgreSQL.
>>
>>Any info will very very important .
>>
>>Thanks !!
>>
>>sending to informix-list
>>
>>
> Hi,
> we are evaluating going from SE to Postgres. So far the biggest
> gotcha was having to use transactions, and the biggest gotcha with that
> was commiting work to the database closes all open cursors.

So you haven't got to the performance testing part yet?

--
Strewth! Stick a sock in it, Sheila!

My Name Is Bruce and I'm A Sock Puppet wrote:

>
>
>So you haven't got to the performance testing part yet?
>
>
>
It's not really an issue. At our busiest site we would have maybe one
database update to a single record every few seconds for most of the
day. We have a period of reporting in the morning which prints to a dot
matrix printer. I'm expecting Postgres to be faster than a dot matrix.
End of week/season/year can take a while but we're still talking seconds
under SE. Postgres can take minutes if it likes - copying the data
offsite over the WAN is the real time hog.

We have deployed Postgres twice in a limited capacity to sites with far
less traffic and experienced no performance issues.

Now compare that with the hoops we needed to jump through to get SE to
run on RHEL3 or RH9, tack on a 50% hike in support and think about how
many people are likely to be familiar with Postgres in 5 years as
opposed to Informix.

It's really going to come down to why Victor is looking to change, and
performance may not be the reason.

--
Scott Burns
Mirrabooka Systems

Tel +61 7 3857 7899
Fax +61 7 3857 1368

Guys;

There is Informix compatibility patch for PG and ecpg compiler:

http://gborg.postgresql.org/project/...rojdisplay.php

There is allready patched code available from:

http://informix.fastcrypt.com/

Older RPM's:

http://informix.postgresintl.com/

We are using them as part of Aubit 4GL compiler project.

There is at least one company that is using them in production
situation.

HTH,
Andrej Falout




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

Andrej Falout wrote:

>Guys;
>
>There is Informix compatibility patch for PG and ecpg compiler:
>
>http://gborg.postgresql.org/project/...rojdisplay.php
>
>There is allready patched code available from:
>
>http://informix.fastcrypt.com/
>
>Older RPM's:
>
>http://informix.postgresintl.com/
>
>We are using them as part of Aubit 4GL compiler project.
>
>There is at least one company that is using them in production
>situation.
>
>HTH,
>Andrej Falout
>
>
>
>
Thanks for that link. I've thought of two more issues over the
weekend but hopefully your link will help:

1) ecpg will not allow you to prepare a statement until you have a
database open. This means you cannot determine database at runtime
unless you use the core C function to do it.

2) ecpg does not allow arrays of host variables. My boss noticed this
so I'm not too sure of any extra details.

--
Scott Burns
Mirrabooka Systems

Tel +61 7 3857 7899
Fax +61 7 3857 1368

If you're going via 4GL then Aubit4GL takes care of both of these issues (as
well as a lot more - for example, putting in the 'AS' for column aliases
and re-writing UPDATE statements in ANSI syntax) .

We've already successfully migrated a large system from Informix SE to
Postgres with just a few 4gl source code changes..



This example program :

main
define lv_arr array[10] of char(1)
define lv_mydb char(64)
let lv_mydb=arg_val(1)

database lv_mydb
create table bibble( a integer)
insert into bibble values(1)

select a into lv_arr[4] from bibble

display lv_arr[4]
end main


Compiles and runs fine with Aubit4GL talking to a postgres database via ecpg


If doing it directly in esqlc/ecpg -

1) the variable in a database statement - you don't prepare it you
'connect'
EXEC SQL CONNECT TO $s AS 'sessionname';

2) Select into a variable then copy it to the array afterwards.





Scott Burns wrote:

> Andrej Falout wrote:
>
>>Guys;
>>
>>There is Informix compatibility patch for PG and ecpg compiler:
>>
>>http://gborg.postgresql.org/project/...rojdisplay.php
>>
>>There is allready patched code available from:
>>
>>http://informix.fastcrypt.com/
>>
>>Older RPM's:
>>
>>http://informix.postgresintl.com/
>>
>>We are using them as part of Aubit 4GL compiler project.
>>
>>There is at least one company that is using them in production
>>situation.
>>
>>HTH,
>>Andrej Falout
>>
>>
>>
>>
> Thanks for that link. I've thought of two more issues over the
> weekend but hopefully your link will help:
>
> 1) ecpg will not allow you to prepare a statement until you have a
> database open. This means you cannot determine database at runtime
> unless you use the core C function to do it.
>
> 2) ecpg does not allow arrays of host variables. My boss noticed this
> so I'm not too sure of any extra details.
>