Migrating DDL from Oracle to Informix
Lauri needed to convert an Oracle schema's DDL into Informix and couldn't find the IBM Migration Toolkit (MTK), since IBM's page redirected to Database Conversion Workbench, which doesn't support Informix. One reply said MTK was dropped and suggested hand-converting per the Redbook plus cleanup of odd data types. Art Kagel supplied a still-working IBM download link (Informix is an option in the questionnaire) and also suggested ER tools like ERwin or Dezign as an alternative. Lauri installed MTK and successfully converted the DDL, noting extent information isn't carried over but foreign keys come out correctly; Art added that MTK is unmaintained since 11.10 so newer types like BIGINT aren't used.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, I am in the process of creating an Informix database based on DDL from an Oracle schema. I found an IBM Redbook with a reference to IBM Migration toolkit (MTK), but the link forwarded me to a new product called Database Conversion Workbench. I could find no reference to Informix there - does it support Informix? Is the MTK still somewhere to be found? I would rather not start messing with IBM Data Studio. Thanks, Lauri Pietarinen
Hello, Lauri. Unfortunately, IBM MTK has been discontinued. It has some serious issues, so the project was cancelled. IBM Informix 12.10 has almost everything you want, in terms of DDL, related to Oracle compatibility. So it must not be a hard work. My suggestion: take the Oracle DDL, do the basics convertion through the Redbook recommendations, and then do a fine tuning, searching for strange data types in the database model, and correct them. Oracle UDRs must not be a problem for you. In case you are migrating to an older Informix engine, I should strongly consider an upgrade of your engine, in order to ease your job. Hope this helps. Best regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: lauri.pietarinen@relational-consulting.com > Subject: Migrating DDL from Oracle to Informix [32765] > Date: Fri, 21 Mar 2014 07:00:17 -0400 > > Hi, > > I am in the process of creating an Informix database based on DDL from an > Oracle schema. I found an IBM Redbook with a reference to IBM Migration > toolkit (MTK), but the link forwarded me to a new product called Database > Conversion Workbench. > > I could find no reference to Informix there - does it support Informix? > > Is the MTK still somewhere to be found? I would rather not start messing with > IBM Data Studio. > > Thanks, > Lauri Pietarinen > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Sorry, I forgot to tell you. DCW is not Informix compatible. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant From: alexandre@briug.org To: ids@iiug.org Subject: RE: Migrating DDL from Oracle to Informix [32765] Date: Fri, 21 Mar 2014 08:36:17 -0300 Hello, Lauri. Unfortunately, IBM MTK has been discontinued. It has some serious issues, so the project was cancelled. IBM Informix 12.10 has almost everything you want, in terms of DDL, related to Oracle compatibility. So it must not be a hard work. My suggestion: take the Oracle DDL, do the basics convertion through the Redbook recommendations, and then do a fine tuning, searching for strange data types in the database model, and correct them. Oracle UDRs must not be a problem for you. In case you are migrating to an older Informix engine, I should strongly consider an upgrade of your engine, in order to ease your job. Hope this helps. Best regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: lauri.pietarinen@relational-consulting.com > Subject: Migrating DDL from Oracle to Informix [32765] > Date: Fri, 21 Mar 2014 07:00:17 -0400 > > Hi, > > I am in the process of creating an Informix database based on DDL from an > Oracle schema. I found an IBM Redbook with a reference to IBM Migration > toolkit (MTK), but the link forwarded me to a new product called Database > Conversion Workbench. > > I could find no reference to Informix there - does it support Informix? > > Is the MTK still somewhere to be found? I would rather not start messing with > IBM Data Studio. > > Thanks, > Lauri Pietarinen > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Lauri: The IBM Migration Toolkit was extended for use converting to Informix, yes, in typical IBM fashion, it's just not reported on the download and description pages. If you go to the FAQ page for the product it is there and the download queationaire does ask if your target database is Informix. Here's the download link: https://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2006-10-18+07%3A 20%3A33.935737R&cat=database&fam=&s=&S_TACT=&S_CMP=&st=3&sp=20 You will have to use you IBM id to login and answer the questionaire before getting to the actual download link, but it works. An alternative, BTW, for the schema itself, would be to import the Oracle schema into an ER design tool like ERWin or Dezign for Databases and export it to Informix. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on 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 Fri, Mar 21, 2014 at 7:00 AM, LAURI PIETARINEN < lauri.pietarinen@relational-consulting.com> wrote: > Hi, > > I am in the process of creating an Informix database based on DDL from an > Oracle schema. I found an IBM Redbook with a reference to IBM Migration > toolkit (MTK), but the link forwarded me to a new product called Database > Conversion Workbench. > > I could find no reference to Informix there - does it support Informix? > > Is the MTK still somewhere to be found? I would rather not start messing > with > IBM Data Studio. > > Thanks, > Lauri Pietarinen > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c36dfc7d6b6204f51c6237
Hi Art, and thanks for the link to the (discontinued?) MTK! I installed it and managed to convert the Oracle DDL to Informix. It looks like the extent-information from the Oracle DDL are not transfered to Informix, though. But it is a great help to get all the foreign keys with the right syntax out of the box. Lauri
Great! Glad it helped. MTK is not so much discontinued as no longer maintained. It hasn't been updated for new Informix features that a conversion might be able to take advantage of since v11.10. So, as an example, large numerics might be converted to DECIMAL or INT8 where using 11.70/12.10 features you might want it to be implemented as BIGINT instead. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on 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 Mon, Mar 24, 2014 at 11:10 AM, LAURI PIETARINEN < lauri.pietarinen@relational-consulting.com> wrote: > Hi Art, > > and thanks for the link to the (discontinued?) MTK! I installed it and > managed > to convert the Oracle DDL to Informix. It looks like the extent-information > from the Oracle DDL are not transfered to Informix, though. But it is a > great > help to get all the foreign keys with the right syntax out of the box. > > Lauri > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1133d17ae1069704f55c207b
Hi Lauri, I missed/deleted the email... Please can you forward the MTK link to me... this may well be of use for a project I have in mind. On 24 March 2014 15:10, LAURI PIETARINEN < lauri.pietarinen@relational-consulting.com> wrote: > Hi Art, > > and thanks for the link to the (discontinued?) MTK! I installed it and > managed > to convert the Oracle DDL to Informix. It looks like the extent-information > from the Oracle DDL are not transfered to Informix, though. But it is a > great > help to get all the foreign keys with the right syntax out of the box. > > Lauri > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Nick Lello | Web Architect o +44 (0) 843.330.9374 | o 503.284.7581 ext. 418 | m +44 (0) 750.890.3456 | Skype: nicholas.lello Email: nick.lello at rentrak.com RENTRAK | www.rentrak.com | NASDAQ: RENT --089e01176955ed467c04f56c4a03
Nick: If you miss something from the forums you can always go to the online forum pages on the IIUG web site and search the threads. Anyway, here's the download link: https://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2006-10-18+07%3A 20%3A33.935737R&cat=database&fam=&s=&S_TACT=&S_CMP=&st=3&sp=20 You will have to use you IBM id to login and answer the questionaire before getting to the actual download link, but it works. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on 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, Mar 25, 2014 at 7:09 AM, Nick Lello <nick.lello@rentrakmail.com>wrote: > Hi Lauri, > > I missed/deleted the email... Please can you forward the MTK link to me... > this may well be of use for a project I have in mind. > > On 24 March 2014 15:10, LAURI PIETARINEN < > lauri.pietarinen@relational-consulting.com> wrote: > > > Hi Art, > > > > and thanks for the link to the (discontinued?) MTK! I installed it and > > managed > > to convert the Oracle DDL to Informix. It looks like the > extent-information > > from the Oracle DDL are not transfered to Informix, though. But it is a > > great > > help to get all the foreign keys with the right syntax out of the box. > > > > Lauri > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > > Nick Lello | Web Architect > o +44 (0) 843.330.9374 | o 503.284.7581 ext. 418 | m +44 (0) 750.890.3456 > | Skype: nicholas.lello > Email: nick.lello at rentrak.com > RENTRAK | www.rentrak.com | NASDAQ: RENT > > --089e01176955ed467c04f56c4a03 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c3735a527fc004f56cb1a2
Thanks for the links On 25 March 2014 11:32, Art Kagel <art.kagel@gmail.com> wrote: > Nick: > > If you miss something from the forums you can always go to the online forum > pages on the IIUG web site and search the threads. Anyway, here's the > download link: > > > > https://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2006-10-18+07%3A 20%3A33.935737R&cat=database&fam=&s=&S_TACT=&S_CMP=&st=3&sp=20 > > You will have to use you IBM id to login and answer the questionaire before > getting to the actual download link, but it works. > > Art > > Art S. Kagel, Principal Consultant > ASK Database Management > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on 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, Mar 25, 2014 at 7:09 AM, Nick Lello <nick.lello@rentrakmail.com > >wrote: > > > Hi Lauri, > > > > I missed/deleted the email... Please can you forward the MTK link to > me... > > this may well be of use for a project I have in mind. > > > > On 24 March 2014 15:10, LAURI PIETARINEN < > > lauri.pietarinen@relational-consulting.com> wrote: > > > > > Hi Art, > > > > > > and thanks for the link to the (discontinued?) MTK! I installed it and > > > managed > > > to convert the Oracle DDL to Informix. It looks like the > > extent-information > > > from the Oracle DDL are not transfered to Informix, though. But it is a > > > great > > > help to get all the foreign keys with the right syntax out of the box. > > > > > > Lauri > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > -- > > > > Nick Lello | Web Architect > > o +44 (0) 843.330.9374 | o 503.284.7581 ext. 418 | m +44 (0) > 750.890.3456 > > | Skype: nicholas.lello > > Email: nick.lello at rentrak.com > > RENTRAK | www.rentrak.com | NASDAQ: RENT > > > > --089e01176955ed467c04f56c4a03 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a11c3735a527fc004f56cb1a2 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Nick Lello | Web Architect o +44 (0) 843.330.9374 | o 503.284.7581 ext. 418 | m +44 (0) 750.890.3456 | Skype: nicholas.lello Email: nick.lello at rentrak.com RENTRAK | www.rentrak.com | NASDAQ: RENT --001a1134635a5a10f604f56da526