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.
- 最新
- 最多得票
- 最多評論
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/
相關內容
AWS 官方已更新 2 年前- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前
- AWS 官方已更新 1 年前
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.