Replicating between Informix 11.50FC7/11.70FC2 and

Posted in 2011

Jeff Filippi — Wed, 15 Jun 2011 16:23:01 — source: IIUG Forums & Mailing Lists

Is there a preferred way to replicate to/from Informix (11.50FC7 or 11.70FC7 - Linux) and SQL Server 2005/2008? I found information about setting up Informix as a Linked Server in SQL Server. Is there any other alternatives. Thanks, Jeff Jeffrey J. Filippi Integrated Data Consulting, LLC 104 Cottonwood Dr. Streamwood, IL 60107 (P) 630-842-3608 (F) 630-497-1762 jeff.filippi@itdataconsulting.com www.itdataconsulting.com <http://www.itdataconsulting.com/>; Description: Cert-Info-Mgmt_color Description: Description: jfilippi_BPMark_web_list

↪ replying to Jeff Filippi

Art Kagel — Wed, 15 Jun 2011 16:37:55 — source: IIUG Forums & Mailing Lists

An MS SQL Server linked server will let SQL Server apps query Informix databases as if they were local to SQL Server. You can do actual replication yourself by writting to the Informix Change Data Capture API (CDC) and/or the SQL Server CDC API if you want to go bidirectional. There are also third party products that you can use. One, dbMoto from Hit software (http://www.hitsw.com/products_services/dbmoto/dbmoto.html) had been using triggers installed in Informix, but the new release which just came out is now using the CDC API for newer servers (IDS 11.50+) that have it. I believe they still support trigger based replication for earlier IDS versions. 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 Wed, Jun 15, 2011 at 12:23 PM, Jeff Filippi < jeff.filippi@itdataconsulting.com> wrote: > Is there a preferred way to replicate to/from Informix (11.50FC7 or > 11.70FC7 > - Linux) and SQL Server 2005/2008? > > I found information about setting up Informix as a Linked Server in SQL > Server. > > Is there any other alternatives. > > Thanks, Jeff > > Jeffrey J. Filippi > > Integrated Data Consulting, LLC > > 104 Cottonwood Dr. > > Streamwood, IL 60107 > > (P) 630-842-3608 > > (F) 630-497-1762 > > jeff.filippi@itdataconsulting.com > > www.itdataconsulting.com <http://www.itdataconsulting.com/>; > > Description: Cert-Info-Mgmt_color > > Description: Description: jfilippi_BPMark_web_list > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec5014b95013b6a04a5c2c631

↪ replying to Art Kagel

Richard — Wed, 15 Jun 2011 18:00:29 — source: IIUG Forums & Mailing Lists

Or just use the CDC product and avoid writing code to do the same thing. :) Dick Snoke IBM ChannelWorks dsnoke@us.ibm.com (404) 487-1595 From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org Date: 06/15/11 12:40 PM Subject: Re: Replicating between Informix 11.50FC7/11.7.... [24045] Sent by: ids-bounces@iiug.org An MS SQL Server linked server will let SQL Server apps query Informix databases as if they were local to SQL Server. You can do actual replication yourself by writting to the Informix Change Data Capture API (CDC) and/or the SQL Server CDC API if you want to go bidirectional. There are also third party products that you can use. One, dbMoto from Hit software (http://www.hitsw.com/products_services/dbmoto/dbmoto.html) had been using triggers installed in Informix, but the new release which just came out is now using the CDC API for newer servers (IDS 11.50+) that have it. I believe they still support trigger based replication for earlier IDS versions. 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 Wed, Jun 15, 2011 at 12:23 PM, Jeff Filippi < jeff.filippi@itdataconsulting.com> wrote: > Is there a preferred way to replicate to/from Informix (11.50FC7 or > 11.70FC7 > - Linux) and SQL Server 2005/2008? > > I found information about setting up Informix as a Linked Server in SQL > Server. > > Is there any other alternatives. > > Thanks, Jeff > > Jeffrey J. Filippi > > Integrated Data Consulting, LLC > > 104 Cottonwood Dr. > > Streamwood, IL 60107 > > (P) 630-842-3608 > > (F) 630-497-1762 > > jeff.filippi@itdataconsulting.com > > www.itdataconsulting.com <http://www.itdataconsulting.com/>; > > Description: Cert-Info-Mgmt_color > > Description: Description: jfilippi_BPMark_web_list > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec5014b95013b6a04a5c2c631 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Richard

Jeff Filippi — Thu, 16 Jun 2011 12:36:15 — source: IIUG Forums & Mailing Lists

Thanks Art & Dick -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Richard Snoke Sent: Wednesday, June 15, 2011 1:00 PM To: ids@iiug.org Subject: Re: Replicating between Informix 11.50FC7/11.7.... [24046] Or just use the CDC product and avoid writing code to do the same thing. :) Dick Snoke IBM ChannelWorks dsnoke@us.ibm.com (404) 487-1595 From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org Date: 06/15/11 12:40 PM Subject: Re: Replicating between Informix 11.50FC7/11.7.... [24045] Sent by: ids-bounces@iiug.org An MS SQL Server linked server will let SQL Server apps query Informix databases as if they were local to SQL Server. You can do actual replication yourself by writting to the Informix Change Data Capture API (CDC) and/or the SQL Server CDC API if you want to go bidirectional. There are also third party products that you can use. One, dbMoto from Hit software (http://www.hitsw.com/products_services/dbmoto/dbmoto.html) had been using triggers installed in Informix, but the new release which just came out is now using the CDC API for newer servers (IDS 11.50+) that have it. I believe they still support trigger based replication for earlier IDS versions. 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 Wed, Jun 15, 2011 at 12:23 PM, Jeff Filippi < jeff.filippi@itdataconsulting.com> wrote: > Is there a preferred way to replicate to/from Informix (11.50FC7 or > 11.70FC7 > - Linux) and SQL Server 2005/2008? > > I found information about setting up Informix as a Linked Server in > SQL Server. > > Is there any other alternatives. > > Thanks, Jeff > > Jeffrey J. Filippi > > Integrated Data Consulting, LLC > > 104 Cottonwood Dr. > > Streamwood, IL 60107 > > (P) 630-842-3608 > > (F) 630-497-1762 > > jeff.filippi@itdataconsulting.com > > www.itdataconsulting.com <http://www.itdataconsulting.com/>; > > Description: Cert-Info-Mgmt_color > > Description: Description: jfilippi_BPMark_web_list > > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec5014b95013b6a04a5c2c631 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.