DMS not replicating chr(0) from source to target
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
chr(0) is null , which is not supported in Postgres. Reference: https://www.postgresql.org/message-id/47CC2576.9090609%40netwolves.com
Try replacing chr(0) with some other character. such as chr(1).
Relevant questions
Do source filters speed up DMS from AWS RDS to S3?
asked 6 months agoDMS not replicating addition of new columns to source
asked a month agoDMS - How to retain non-ASCII values when running DMS task from MySQL source to Redshift target
asked 3 months agoDMS - When to switch the application to the new target database
Accepted Answerasked 5 months agoDMS not replicating chr(0) from source to target
asked 2 months agoApplying column filters in DMS Task for source MongoDB and target Postgres
asked 19 days agoCan DMS do mapping that is not simply 1-1 from source to target?
Accepted Answerasked a month agoDoes DMS support updating value of sequences in the target for postgres to postgres data migration?
asked a month agoDMS CDC Verification
Accepted Answerasked 3 years agoUse special character in DB password DMS endpoint
asked 5 years ago