Re sync replicate tables
Hello every one , Recently we migrated subset of data from one of our production servers to a new database server. After the migration we did not start the replication for about a week. During the non replication time ( about a week) they were updates to our old server which are not propagated the new one . I believe there are about 100 tables replicated ( We do not replicate the entire database).Now I want to extract the missing data from the old server to the new server. These two servers are a part of 3 other servers in the replication. The 100 tables in question could have been updated in any one of those 3 servers All our engines are on HP-ux Version 11 and IDS 10 fc4 My goal is to resync all those replication table in all the 5 engines. I am just looking for any body who have any tools or if you know off any company has a product which can accomplish this task . I highly appreciate any info Thanks Murali nanduri
IDS10xC4 has the "cdr sync" command. That might be the best solution. ------------------------------------- Madison Pruet, STSM IDS Replication Architect = "MURALIKRISHNA = NANDURI" = <mk_nanduri@hotma = To il.com> ids@iiug.org = Sent by: = cc ids-bounces@iiug. = org Subj= ect Re sync replicate tables [13248= ] = 08/28/2008 07:55 = PM = = = Please respond to = ids@iiug.org = = = Hello every one , Recently we migrated subset of data from one of our production servers = to a new database server. After the migration we did not start the replicati= on for about a week. During the non replication time ( about a week) they were= updates to our old server which are not propagated the new one . I beli= eve there are about 100 tables replicated ( We do not replicate the entire database).Now I want to extract the missing data from the old server to= the new server. These two servers are a part of 3 other servers in the replication. The 100 tables in question could have been updated in any = one of those 3 servers All our engines are on HP-ux Version 11 and IDS 10 fc4 My goal is to resync all those replication table in all the 5 engines. I am just looking for any body who have any tools or if you know off an= y company has a product which can accomplish this task . I highly appreciate any info Thanks Murali nanduri ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
2008/8/29 MURALIKRISHNA NANDURI <mk_nanduri@hotmail.com>: > Hello every one , > > Recently we migrated subset of data from one of our production servers to a > new database server. After the migration we did not start the replication for > about a week. During the non replication time ( about a week) they were > updates to our old server which are not propagated the new one . I believe > there are about 100 tables replicated ( We do not replicate the entire > database).Now I want to extract the missing data from the old server to the > new server. These two servers are a part of 3 other servers in the > replication. The 100 tables in question could have been updated in any one of > those 3 servers > All our engines are on HP-ux Version 11 and IDS 10 fc4 > > My goal is to resync all those replication table in all the 5 engines. > > I am just looking for any body who have any tools or if you know off any > company has a product which can accomplish this task . > > I highly appreciate any info > Thanks > Murali nanduri > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > Murali You may find the quickest, simplest and safest way is to migrate the data again, when the databases are quiet, and then immediately start replication. You could script to detect changes and apply them, or investigate cdr sync, but these could take some time. If you can get a quiet period migrating the data would be best. Keith