Oninit cdi / Archive
Talk to an expert →

Looking for a recommendation for a 3rd party data

Posted in 2011

Topics: High Availability & Replication

Jonathan — — source: IIUG Forums & Mailing Lists

Good afternoon. Aside from using Informix-to-Informix replication (HDR, ER, SDS, etc. etc.), I'm interested in a recommendation for a 3rd party replication tool to replicate / copy and entire database in Informix over to a different platform like Microsoft SQL. Thanks in advance for any suggestions. Sincerely, Jonathan B. Smaby Pomona College phone: (909) 621-8506 email: jonathan.smaby@pomona.edu http://www.uscgamdr.org/classes http://wwww.facebook.com/JonathanSmaby -- Semper Paratus! "Always Ready!" ------------------------------------------------------------- This message has been scanned by Postini anti-virus software.

↪ replying to Jonathan
Art Kagel — — source: IIUG Forums & Mailing Lists

One option, assuming 11.50 or later, is to use the Change Data Capture (CDC) API to capture changes to the database and then apply them to the copy in SQL Server. The initial migration you will have to do using dbexport and whatever he equivalent SQL Server import or ETL tool is. IBM has a product for this called SyncML. Microsoft's version is MSDN. WisdomForce has DatabaseSync. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) 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, Jan 5, 2011 at 7:04 PM, Jonathan Smaby <Jonathan.Smaby@pomona.edu>wrote: > Good afternoon. > > Aside from using Informix-to-Informix replication (HDR, ER, SDS, etc. > etc.), > I'm interested in a recommendation for a 3rd party replication tool to > replicate / copy and entire database in Informix over to a different > platform > like Microsoft SQL. > > Thanks in advance for any suggestions. > > Sincerely, > > Jonathan B. Smaby > Pomona College > phone: (909) 621-8506 > email: jonathan.smaby@pomona.edu > http://www.uscgamdr.org/classes > http://wwww.facebook.com/JonathanSmaby > -- > Semper Paratus! "Always Ready!" > > ------------------------------------------------------------- > This message has been scanned by Postini anti-virus software. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5c1eb4b8e91049923848f

↪ replying to Jonathan
Richard — — source: IIUG Forums & Mailing Lists

Hi, Take a look at IBM Infosphere Change Data Capture, aka CDC. CDC provides heterogeneous replication among the major RDBMS products. It's very good, and it understands things like date format differences so you don't have to do anything. Cheers, Dick Snoke IBM ChannelWorks dsnoke@us.ibm.com (404) 487-1595 http://www.ibm.com/partnerworld From: "Jonathan Smaby" <Jonathan.Smaby@pomona.edu> To: ids@iiug.org Date: 01/05/11 07:04 PM Subject: Looking for a recommendation for a 3rd party d.... [22351] Sent by: ids-bounces@iiug.org Good afternoon. Aside from using Informix-to-Informix replication (HDR, ER, SDS, etc. etc.), I'm interested in a recommendation for a 3rd party replication tool to replicate / copy and entire database in Informix over to a different platform like Microsoft SQL. Thanks in advance for any suggestions. Sincerely, Jonathan B. Smaby Pomona College phone: (909) 621-8506 email: jonathan.smaby@pomona.edu http://www.uscgamdr.org/classes http://wwww.facebook.com/JonathanSmaby -- Semper Paratus! "Always Ready!" ------------------------------------------------------------- This message has been scanned by Postini anti-virus software. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Richard
jack.parker4@verizon.net — — source: IIUG Forums & Mailing Lists

This isn't a recommendation because I've never tried the software, but Golden Gate has something that supposedly does this. j. Jan 6, 2011 12:58:22 PM, ids@iiug.org wrote: =========================================== Hi, Take a look at IBM Infosphere Change Data Capture, aka CDC. CDC provides heterogeneous replication among the major RDBMS products. It's very good, and it understands things like date format differences so you don't have to do anything. Cheers, Dick Snoke IBM ChannelWorks dsnoke@us.ibm.com (404) 487-1595 http://www.ibm.com/partnerworld From: "Jonathan Smaby" To: ids@iiug.org Date: 01/05/11 07:04 PM Subject: Looking for a recommendation for a 3rd party d.... [22351] Sent by: ids-bounces@iiug.org Good afternoon. Aside from using Informix-to-Informix replication (HDR, ER, SDS, etc. etc.), I'm interested in a recommendation for a 3rd party replication tool to replicate / copy and entire database in Informix over to a different platform like Microsoft SQL. Thanks in advance for any suggestions. Sincerely, Jonathan B. Smaby Pomona College phone: (909) 621-8506 email: jonathan.smaby@pomona.edu http://www.uscgamdr.org/classes http://wwww.facebook.com/JonathanSmaby -- Semper Paratus! "Always Ready!" ------------------------------------------------------------- This message has been scanned by Postini anti-virus software. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Jonathan
Christine — — source: IIUG Forums & Mailing Lists

We have successfully used Hit Software's DBMOTO to replicate from Informix to SQL Server. Regards, Christine Bizukiewicz Shubert Ticketing -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jonathan Smaby Sent: Wednesday, January 05, 2011 7:04 PM To: ids@iiug.org Subject: Looking for a recommendation for a 3rd party d.... [22351] Good afternoon. Aside from using Informix-to-Informix replication (HDR, ER, SDS, etc. etc.), I'm interested in a recommendation for a 3rd party replication tool to replicate / copy and entire database in Informix over to a different platform like Microsoft SQL. Thanks in advance for any suggestions. Sincerely, Jonathan B. Smaby Pomona College phone: (909) 621-8506 email: jonathan.smaby@pomona.edu http://www.uscgamdr.org/classes http://wwww.facebook.com/JonathanSmaby -- Semper Paratus! "Always Ready!" ------------------------------------------------------------- This message has been scanned by Postini anti-virus software. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary