IDS Forum

Re: RE: Migrating from 7.31 to 11.70 with ER?

Posted By: Nagaraju Inturi
Date: Thursday, 26 April 2012, at 4:41 p.m.

In Response To: Re: RE: Migrating from 7.31 to 11.70 with ER? (LUKE SIMMONS)

'cdr sync' and 'cdr check' only works with 10.00x and later versions only.
For 7.31 server, you can scan all rows in the table , group them into
smaller transactions and perform dummy update on these rows (some thing
like update tab set col1=col1) to synchronize the data. Make sure to
define "timestamp" conflict rule to allow converting update operation to
insert operation if row is missing at target server. Also you will have to
synchronize parent table first before synchronizing child table if
replicated tables have foreign key constraints.

I remember Madison has an esqlc program which does this. This tool does
output sql statements after scanning the tables. Not sure if he still has
this tool or not. I couldn't find it in IIUG member area or in my local
hard disk.

Thanks & Regards,
Nagaraju

From: "LUKE SIMMONS" <luke.simmons@vgregion.se>
To: ids@iiug.org,
Date: 04/26/2012 07:41 AM
Subject: Re: RE: Migrating from 7.31 to 11.70 with ER? [26843]
Sent by: ids-bounces@iiug.org

I think I've done exactly that. The global catalog is on 11.70. The
replication is being run from 11.70. I assume that's what you are
referring
to.

Unfortunately, one can't run cdr sync... from 11.70 when replicating over
a
7.31 server due to incompatible syscdr tables. Or at least that's what it
looks like to me (see my post above).

As a workaround, I'm considering just creating a dummy column on each
table,
performing an insert on that column to sync everything across. With the
exception of performing a crap load of transactions, in some preliminary
tests, this has worked pretty good.

*******************************************************************************

Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Migrating from 7.31 to 11.70 with ER?
  LUKE SIMMONS -- Friday, 20 April 2012, at 9:06 a.m.
  • RE: Migrating from 7.31 to 11.70 with ER?
    Andrew Grantham -- Friday, 20 April 2012, at 9:22 a.m.
    • RE: Migrating from 7.31 to 11.70 with ER?
      Alexandre Marini -- Friday, 20 April 2012, at 9:54 a.m.
  • Re: Migrating from 7.31 to 11.70 with ER?
    Madison Pruet -- Friday, 20 April 2012, at 9:34 a.m.
    • Re: Migrating from 7.31 to 11.70 with ER?
      LUKE SIMMONS -- Friday, 20 April 2012, at 10:33 a.m.
      • RE: Migrating from 7.31 to 11.70 with ER?
        Alexandre Marini -- Friday, 20 April 2012, at 11:03 a.m.
      • Re: Migrating from 7.31 to 11.70 with ER?
        Art Kagel -- Friday, 20 April 2012, at 3:17 p.m.
  • Re: Migrating from 7.31 to 11.70 with ER?
    Art Kagel -- Friday, 20 April 2012, at 3:07 p.m.
    • Re: Migrating from 7.31 to 11.70 with ER?
      Madison Pruet -- Friday, 20 April 2012, at 3:16 p.m.
      • Re: Migrating from 7.31 to 11.70 with ER?
        Art Kagel -- Friday, 20 April 2012, at 3:20 p.m.
        • Re: Migrating from 7.31 to 11.70 with ER?
          LUKE SIMMONS -- Monday, 23 April 2012, at 5:57 a.m.
    • Re: Migrating from 7.31 to 11.70 with ER?
      LUKE SIMMONS -- Thursday, 26 April 2012, at 5:00 a.m.
      • RE: Migrating from 7.31 to 11.70 with ER?
        Alexandre Marini -- Thursday, 26 April 2012, at 7:26 a.m.
        • Re: RE: Migrating from 7.31 to 11.70 with ER?
          LUKE SIMMONS -- Thursday, 26 April 2012, at 8:40 a.m.
          • RE: Migrating from 7.31 to 11.70 with ER?
            Alexandre Marini -- Thursday, 26 April 2012, at 9:05 a.m.
          • Re: RE: Migrating from 7.31 to 11.70 with ER?
            Nagaraju Inturi -- Thursday, 26 April 2012, at 4:41 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.