Migration from IDS to Postgresql

Hi, I am currently using IDS ver 10.x. I need to now migrate to Postgresql. Wanted some insight/references on the following lines: 1) Compliance of SQL in Informix, Postgresql 2) What kind of challenges to prepare for 3) Any good practices, case study, tools which can help in this direction. Regards, Gurpreet.

See below: Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, May 28, 2013 at 2:11 AM, GURPREET SACHDEVA <gusachde@cisco.com>wrote: > Hi, > > I am currently using IDS ver 10.x. I need to now migrate to Postgresql. > Wanted > some insight/references on the following lines: > 1) Compliance of SQL in Informix, Postgresql > No idea about PostgreSQL's level of SQL Standard support. Informix 10.00 supported ANSI '89 SQL for the most part with some extensions. > 2) What kind of challenges to prepare for > PostgreSQL isn't going to perform as well as Informix on the same hardware. > 3) Any good practices, case study, tools which can help in this direction. > Best practice: Leave your database in Informix! ;-( > > Regards, > Gurpreet. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b34330ecc8d0c04ddc4846c