Post reply

Structure differences on Oracle subscriber

  • August 5, 2014 at 1:35 pm

    #288741

    Hi.

    In reviewing our replication recently , we have found that there is structure differences between the two replicated schema on the destination/oracle end, even though the structure between replication scenarios appears the same. The primary differences is in datatypes and lengths between the two environments…for instance:

    Primary (sql)

    TABLE_NAMECOLUMN_NAMEDATA_TYPE LENGTH

    tblAcct CurrAct NVARCHAR2 20

    Replica (oracle)

    TABLE_NAMECOLUMN_NAMEDATA_TYPE LENGTH

    tblAcct CurrAct NVARCHAR2 30

    What could account for these differences?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply