Hi,
Chr(0) is present in the source data and dms is not migrating this character to target. DMS transfers all non-printable characters except chr(0).
Due to this DMS reports these records as mismatched records. Is there any workaround for this in DMS to retain chr(0) in target.
Source DB:rds oracle
Target :AUrora postgresql 13.X
Sample insert query:
insert into non_ascii_test values (1,'This string doesnt contain non-printable ascii characters');
insert into non_ascii_test values (2,'This string contains non-printable ascii characters'||chr(1)||chr(2)||chr(3)||chr(4)||chr(5)||chr(6)||chr(7)||chr(8)||chr(9));
insert into non_ascii_test values (3,'This string contains non-printable ascii characters'||chr(1)||chr(2)||chr(3)||chr(4)||chr(5)||chr(6)||chr(7)||chr(8)||chr(9));
insert into non_ascii_test values
(6,chr(0)||chr(1)||chr(2)||chr(3)||chr(4)||chr(5)||chr(6)||chr(7)||chr(8)||chr(9)||chr(10)||chr(11)||chr(12)||chr(13)||chr(14)||chr(15)||chr(16)||chr(17)||chr(18)||chr(19)||chr(20)||chr(21)||chr(22)||chr(23)||chr(24)||chr(25)||chr(26)||chr(27)||chr(28)||chr(29)||chr(30)||chr(31)||'test non-ascii print'||chr(0)||chr(1)||chr(2)||chr(3)||chr(4)||chr(5)||chr(6)||chr(7)||chr(8)||chr(9));
Thanks
Bharath