Question regarding OE Replication and making changes to Target DB only - Forum - OpenEdge General - Progress Community

Question regarding OE Replication and making changes to Target DB only

 Forum

Question regarding OE Replication and making changes to Target DB only

  • Hi all,


    I have an OpenEdge 10.2B06 database that is replicated. We are using OE Replication PLUS and make use of the replicated database as our reporting database and run a couple of reports via CyberQuery connecting to the replicated DB via ODBC.

    We have run into the age-old SQL Field width issue and now I am unsure if I need to run the field width adjustment utility on the target only or should I run it on the source and hope it replicates? Anyone done this before? What are your suggestions?

    Thanks in advance

    Regards,

    Mark Davies

  • Mark,

    You just need to update your source and let Replication take over.  We have this issue now and then as well, as our users have Crystal Reports

    Thanks,

    Chris

  • You will be unable to make the change on the target as far as I know. The change should be made on the source and it will replicate. Test it with one field first.

    Sent from my Windows Phone
  • ProgressEmailLogo-png_2D00_150x42x2-png.png
    4TUQ1PS9QGB4-jpg_2D00_70x70x2-jpg.jpg
    James is correct on both accounts.

    You cannot change the schema on the target.

    Any schema changes you make on the source will get replicated to the target.  This includes SQL width.

    One additional note:  this does not apply to structural changes like adding an extent etc.

    Brian

    Sent from my iPad

    Brian Bowman
    Product Management
    Progress Software
    Cell: +1 (603) 801-8259
    Office:+1 (781) 280-4708

    Brian L. Bowman

    bowman@progress.com

  • Hi,

    What about the new 11.6 feature Autonomous Schema Update?

    Will this work when it's enabled on the target database where the queries are executed?

    Thanks, Frank

  • It will work but it will not updated the schema.  So the Automatic Schema Update (ASU) feature will not work on the target database because it is a target database.
     
    We have been discussing this internally and are leaning towards having the SQL engine write a DDL script that could be manually applied to the source.  The other option of having the target database run DDL automatically on the source is very problematic and wrought with potential problems and pitfalls.
     
    I would like to hear your thoughts on this though.
     
    Thanks

    Brian
     
    Brian L. Bowman
     
    Senior Principal Product Manager
    Progress Software Corporation
    14 Oak Park, Bedford, MA, USA 01730
     
    Phone: +1 (603) 801-8259
    Email: bowman@progress.com
     
     

    Brian L. Bowman

    bowman@progress.com

  • I very much like the idea of having an option to generate DDL instead of immediately applying it.  That would permit a nice opportunity to review it first and even possibly distribute it to multiple parties.

    --
    Tom Bascom
    tom@wss.com

  • Although Tom's idea of having an option to generate DDL is interesting, for this specific case I prefer immediately applying the change. Reason is that the application is accepting any data (most is coming via batch processes) and the SQL queries are quite business critical.

  • Generating DDL script would be great.

    Dmitri Levin

    Alphabroder