AWS Schema Conversion Tool - ユーザーガイド

1 AWS Schema Conversion tool Version Schema Conversion tool AWS Schema Conversion tool : Copyright 2019 Amazon Web Services, Inc. and/or its affiliates. All rights 's trademarks and trade dress may not be used in connection with any product or service that is not Amazon's, in any mannerthat is likely to cause confusion among customers, or in any manner that disparages or discredits Amazon. All other trademarks notowned by Amazon are the property of their respective owners, who may or may not be affiliated with, connected to, or sponsored Schema Conversion tool Table of ContentsAWS Schema Conversion tool .. 1 .. 2 .. 3 .. 4 AWS SCT .. 4 .. 5 AWS SCT.

2 5 AWS SCT .. 6 Fedora AWS SCT RPM .. 6 Ubuntu AWS SCT DEB .. 7 Microsoft Windows AWS SCT MSI .. 7 Mac OS AWS SCT .. 8 .. 8 Linux JDBC .. 9 .. 10 AWS SCT .. 11 AWS SCT .. 12 AWS SCT .. 12 AWS .. 13 AWS .. 14 .. 16 .. 16 Union All .. 16 AWS SCT .. 17 .. 19 .. 19 .. 20 .. 21 SCT .. 24 .. 25 .. 26 DB .. 27 .. 29 AWS SCT .. 30 AWS Schema Conversion tool Oracle .. 30 Oracle .. 31 Oracle.

3 31 Oracle PostgreSQL .. 33 Oracle 36 Oracle Amazon RDS 40 Microsoft SQL Server AWS Schema Conversion tool .. 43 : Microsoft SQL 43 : Microsoft SQL Server Windows .. 44 SQL Server .. 45 SQL Server 47 SQL Server 48 SQL Server Amazon RDS SQL 52 AWS Schema Conversion tool MySQL .. 53 : 53 MySQL .. 53 AWS Schema Conversion tool PostgreSQL .. 55 : 55 PostgreSQL .. 56 Version Schema Conversion tool AWS Schema Conversion tool Db2 LUW .. 57 : Db2 57 Db2 LUW .. 59DB2 LUW 61 AWS Schema Conversion tool Amazon Redshift .. 62 : Amazon 62 Redshift .. 63 AWS Schema Conversion tool Oracle DW.

4 64 : Oracle Data 64 OracleDW .. 65 AWS Schema Conversion tool Teradata .. 67 : 67 Teradata .. 67 AWS Schema Conversion tool Netezza .. 70 : 70 Netezza .. 71 AWS Schema Conversion tool Greenplum .. 72 : 72 Greenplum .. 72 AWS Schema Conversion tool Vertica .. 74 : 74 Vertica .. 74 Microsoft SQL Server DW AWS Schema Conversion tool .. 76 : Microsoft SQL Server .. 76 SQLS erverDW .. 76 .. 79 .. 79 .. 80 .. 81 .. 82 WQF .. 83 WQF .. 84 .. 85 .. 88 .. 91 .. 92 .. 93.

5 94 .. 94 .. 94 .. 95 .. 96 .. 97 .. 98 .. 98 .. 99 .. 99 .. 100 .. 100 .. 101 .. 102 .. 103 .. 104 Amazon Redshift .. 105 .. 106 .. 107 .. 108 Version Schema Conversion tool .. 109 .. 110 .. 110 .. 110 .. 111 .. 112 .. 113 .. 114 .. 115 .. 115 .. 116 .. 116 .. 117 .. 117 .. 118 .. 119 Python .. 120 Amazon Redshift .. 120 Amazon Redshift.

6 120 ETL AWS Glue .. 122 .. 123 AWS Glue .. 123 .. 123 AWS SCT UI AWS Glue .. 124 1: .. 125 2: AWS Glue .. 128 AWS Glue Python API .. 129 1: .. 129 2: .. 129 3: AWS Glue .. 130 AWS Schema Conversion tool AWS Database Migration Service .. 133 AWS DMS AWS SCT .. 133 AWS DMS AWS SCT .. 133 .. 134 Amazon Redshift .. 134 .. 136 .. 137 .. 140 AWS SCT .. 141 .. 143 .. 143 AWS SCT .. 144 AWS Snowball .. 146 .. 152 .. 153 LOB .. 156.

7 157 Apache Cassandra Amazon DynamoDB .. 158 Cassandra DynamoDB .. 160 AWS SCT .. 162 .. 164 .. 172 Amazon DynamoDB .. 176 .. 180 SQL .. 181 SQL .. 181 .. 181 Version Schema Conversion tool SQL .. 184 .. 185 .. 185 SQL .. 186 .. 187 DB .. 187 Python .. 188 AWS Python .. 188 .. 188 Lambda .. 189 AWS .. 189 .. 190 .. 192 .. 192 .. 192 .. 193 Oracle.

8 193 .. 194 .. 194 .. 196 .. 197 .. 199 .. 201 .. 203 .. 205 .. 206 .. 208 .. 210 .. 212 .. 214 .. 216 .. 218 .. 220 .. 222 .. 224 Version Schema Conversion tool AWS Schema Conversion tool AWS Schema Conversion tool (AWS SCT) OLTP Amazon Relational Database Service (Amazon RDS) MySQL DB Amazon Aurora DB Amazon RDS PostgreSQL DB AmazonRedshift Amazon EC2 Amazon S3 AWS SCT Amazon S3 AWS (FIPS) AWS SCT (FedRAMP) AWS AWS AWS SCT OLTP Amazon RDS Microsoft SQL Server ( 2008 )

9 MySQL AmazonAurora PostgreSQL AmazonAurora MariaDB , Microsoft SQLS erver MySQL PostgreSQLMySQL ( )Aurora PostgreSQL MySQL PostgreSQLAWS SCT MySQL AuroraMySQL DB Amazon Aurora DB Oracle ( )Aurora MySQL Aurora PostgreSQL MySQL Oracle PostgreSQLP ostgreSQL ( )Aurora MySQL MySQL PostgreSQLIBM Db2 LUW ( )Aurora MySQL MariaDB MySQL PostgreSQL Aurora PostgreSQLA pache Cassandra ( )Amazon DynamoDBSybase ( )Aurora MySQL AuroraPostgreSQL MySQL PostgreSQLAWS SCT Amazon Redshift Greenplum ( )Amazon RedshiftMicrosoft SQL Server ( 2008 )Amazon RedshiftNetezza ( )Amazon RedshiftVersion Schema Conversion tool Amazon Redshift Oracle ( 10 )Amazon RedshiftTeradata ( 13 )Amazon RedshiftVertica ( )Amazon Redshift AWS SCT Amazon RDS AWS SCT AmazonRDS AWS SCT AWS Schema Conversion tool (p.)

10 4) AWS SCT AWS Schema Conversion tool (p. 12) AWS Schema Conversion tool (p. 91) AWS SCT 1 AWS Amazon Redshift AWS SCT (p. 134) AWS SCT AWS DMS AWS SCT AWS Schema Conversion tool AWS Database Migration Service (p. 133) Amazon RDS Amazon Redshift AWS SCT AWS Lambda Python AWS SchemaConversion tool (p.