Skip to Content
avatar image
Former Member

Desynchronize Replica properties for multiple table from replication property in Power designer 16.5

Hello Experts, I am trying to create replicate objects from Source to target model in Power designer 16.5. I have created replicate tables from source to target models and trying to desynchronize replicate objects (Tables) property as I need indexes to be editable from target tables.

I am able to desynchronize individual table but not able to select all at a time and make only indexes editable for 50 tables.

Is there any way in PD 16.5 to change replication property for set of 50 tables in 1 shot instead of manually select 1 by 1 table.

Your help would be appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 04, 2017 at 07:16 PM

    This is where script comes in handy.

    Open the model. Go to Tools->Execute Command->Edit/Run Script. Execute the code


    set Tables=ActiveModel.Tables
    for each t in tables
    if t.replica=true then
    Set ReplInfo = t.SourceReplication
    ReplInfo.delete
    end if
    next

    Add comment
    10|10000 characters needed characters exceeded