Re: Informix to Ingres migration question

Wojtek Rappak <wojtek@cssys.demon.co.uk> wrote in article <CjvymFAPrLP0EwD+@cssys.demon.co.uk>... > Has anyone been involved in an Informix to Ingres database migration or > a port of an Informix-based application to Ingres? > > I realise that any such migration or porting project has a lot of > specific detail, but are there any general issues which come to mind? > (data types, stored procedures, select loops etc). > > Thanks. > -- > ____________________________________________________________________________ __ > Wojtek Rappak BKB Client/Server (UK) > +44 (0)181-691 2089 > For the data migration part of the job I suggest you look at SQLMover which is a production or on-demand tool for DBAs or the DB knowledgeable that allows you to replicate automatically between any ODBC compliant datasource including Oracle, Ingres, Informix, DB2 and SQL Server. SQLMover uses standard, simple or complex SQL Select statement in one end and a INSERT, UPDATE, INSERT then UPDATE, UPDATE the INSERT or DELETE statement towards the destination database table. Data conversion can be performed by using the SQL SELECT CONVERT option or by using string functions in the SELECT query, by using the built in Format Mask functions or by using triggers in the destination database. To evaluate until Oct.31 you can download from www.sqlmover.com (follow the download buttons) and use the evaluation key OSHKSHTD. The key allows you to transfer a limited number of rows per transfer/replication task and max. 5 tasks can be defined. For Data Mart Data Warehousing purposes you can choose to let SQLMover aggregate your data by using SELECT - GROUP BY. That is if you don't want to transfer all details. Peder Holst, pederh@elektrosoft.se