February 7, 2008 at 3:40 am
Hi pals,
We need to replicate few DB2 databases to SQL 2005. We have DB2 server in postion & we have a server class machine with MS Windows 2003 server OS & SQL server 2005 enterprise edition installed & configured in it. What hardware other than this is required for data replication & I first wanna try a small database replication from DB2 to SQL 2005 before we get going on a large scale. I wud be much obliged if any specialists cud lend their helping hands in assiting me to accomplish this project. I am ready to provide u all with other informations that u wanted.
Thanks & Regards,
Rajesh
February 8, 2008 at 6:58 am
AFAIK that is not a supported facility.
SQL200x -> SQL200x is fine (OK the compact editions can only be subscribers)
Oracle -> SQL200x is possible (SQL Enterprise Edition ONLY)
where latter creates lotsa extra tables in the Oracle db (with triggers to populate them), and the LogReader agent consumes such changes, writes to local distribution db and the Distribution Agents then push/pull changes to the subs
So a continuous real-time, transactional repl from DB2 -> SQL200x is NOT an MS option
however you WOULD be able to create a Snapshot-type repl using SSIS and appropriate DB2 data provider to yank out data from DB2 (maybe to write to local Staging db, which is then rippled out to subs via SQL repl). You would have to decide periodicity (say twice per day at 05:00 after overnite batch runs, and 12:30 as intraday), based on change churn, volume etc
- of course some tables will churn lots and others be very slow-moving so you can mix+match
HTH
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply