Conversion to Datatype Results in Error
SQL Server TIMESTAMP fields are being converted to a Postgres BIGINT.
When I run a Data Migration Task with SQL Server as the Source and Postgres as the target, I receive the error below in the RDS logs of the target Postgres instance.
[23476]:ERROR: invalid input syntax for type bigint: "000000000064B0AD" 2023-01-23 21:43:18 UTC:10.220.246.94(54136):administrator@staging:[23476]:CONTEXT: COPY tblDocument, line 1, column thetimestamp: "000000000064B0AD" 2023-01-23 21:43:18 UTC:10.220.246.94(54136):administrator@staging:[23476]:STATEMENT: COPY "dbo"."tblDocument" FROM STDIN WITH DELIMITER ',' CSV NULL 'attNULL' ESCAPE '\'
When I change the datatype of the field tyo BYTEA, no errors.
- Newest
- Most votes
- Most comments
Hello Ross,
Did you have a chance to take a look here? https://docs.aws.amazon.com/dms/latest/sql-server-to-aurora-postgresql-migration-playbook/chap-sql-server-aurora-pg.sql.datatypes.html
Not sure if this would work for you, but there is an option to use SCT as well. https://aws.amazon.com/dms/schema-conversion-tool/
Relevant content
- Accepted Answerasked 2 years ago
AWS OFFICIALUpdated 2 years ago- AWS OFFICIALUpdated 9 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a month ago
Thanks for the answer. I used the SCT to migrate and the conversion chosen was bigint. I have skimmed the documentation you posted and will read it in its entirety tomorrow.