ADMM: Migrate->Snapshot Management How case sensitivity is handled in replicating the table in Snapshot Mgmt.

Garima Jain

• November 21, 2024 09:52

T006 has some case sensitive entries - upper/lower case. When we are replicating this table in Snapshot Management - it's failing saying Replication is successful but appears to have been failed.

We figured out it's failing due to default collation assigned to DB SQL_Latin1_General_CP1_CI_AS and this scenario looks for Case sensitive one.

How such scenarios are handled in Syniti ADMM

 

0

• 

  Rakesh Ananthuni

  • November 21, 2024 10:01

  Hi Garima,
  Please change the collation of MSEHI field in T006 table of snapshot db.

  Regards,
  Rakesh

  0
• 

  Garima Jain

  • November 26, 2024 14:48

  Please suggest as we are not able to use Value Mapping feature of Syniti.

  0

Please sign in to leave a comment.