Stack Overflow
Stack Overflow

Questions tagged [aws-sct]

The AWS Schema Conversion Tool (AWS SCT) automates much of the process of converting your online transaction processing (OLTP) database schema to an Amazon Relational Database Service (Amazon RDS) MySQL DB instance, an Amazon Aurora DB cluster, or a PostgreSQL DB instance.

47 questions
0
votes
0 answers

AWS SCT - MySQL DDL differences

Im trying to use AWS SCT to copy the schema of one aws rds mysql database to another aws rds mysql database (same engine). When applying the schema changes via the AWS SCT tool, i get a few errors mostly similiar You have an error in your SQL…
Kay
  • 17,906
  • 63
  • 162
  • 270
0
votes
1 answer

Bigquery to Redshift data transfer using AWS SCT failing?

I am trying to migrate data from Bigquery to Redshift using this article. I followed through and successfully got till "Start the Local Data Migration Task".I had to setup AWS profile to access "Data Migration View(Other)". AWS profile was setup…
m00s3
  • 124
  • 7
0
votes
1 answer

Convert oracle UDF function with to_number and value_error expection in it to AWS RDS maria db

create or replace FUNCTION num_check (p_string IN VARCHAR2) RETURN NUMBER IS v_new_num NUMBER; BEGIN v_new_num := TO_NUMBER(p_string); RETURN v_new_num; EXCEPTION WHEN VALUE_ERROR THEN RETURN NULL; END num_check;
Arun
  • 1
0
votes
0 answers

Migrate data using AWS SCT CLI

I need to migrate Oracle db to Aurora MySQL, AWS recommended AWS SCT tool. Fro security reasons the databases in private subnets and I can't reach them with my AWS SCT tool on local machine, so I am searching for a way to configure the AWS SCT on…
Haytham
  • 135
  • 1
  • 1
  • 8
0
votes
0 answers

AWS Schema Conversion tool - Insufficient Privileges while connecting to Aurora MySQL

I am trying to migrate SQL Server to Aurora My SQL. When I am trying to run Schema conversion tool, it gives below error when connecting to target (Aurora- MySQL). Insufficient Privileges - The specified account (sa) does not have sufficient…
Mandar
  • 369
  • 2
  • 5
  • 11
0
votes
0 answers

Why is AWS SCT telling me posgresql 13.7 doesn't support json data type

I'm trying to move our database from a mysql rds to postgresql rds, the current database is currently setup on rds, so we are using auroroa for mysql, i found out that aws has a Data Migration service that i can use to live move data to the new…
logax
  • 33
  • 6
0
votes
1 answer

Current setting in postgresql

I'm converting oracle to postgresql using AWS SCT tool. I found the following line in one of function: select (CLOCK_TIMESTAMP() AT TIME ZONE COALESCE(CURRENT_SETTING('aws_oracle_ext.tz', TRUE), 'UTC'))::TIMESTAMP(0) Is there any other alternative…
MAK
  • 6,824
  • 25
  • 74
  • 131
0
votes
1 answer

AWS SCT error while connecting to PostgreSQL 13.4

I get the following error when trying to connect to postgres as a target using AWS SCT: LOADER ERROR: Error executing 'load-contexts' query: org.postgresql.util.PSQLException: ERROR: relation "aws_oracle_context.context" does not exist' It appears…
SevVirpio
  • 1
  • 2
0
votes
1 answer

How does Oracle store integers?

I have been tasked to convert some Oracle DB's to Postgresql, using AWS Schema Conversion Tool. Oracle only has the Number[(precision[,scale])] type. It would seem that Oracle stores integers using fixed-point. A lot of ID columns are defined as…
David Kerr
  • 1,376
  • 2
  • 15
  • 20
0
votes
0 answers

Where is Windows Authentication library located?

I want to use AWS Schema Conversion Tool to migrate from SQL Server to Redshift. When using the tool a path to Windows Authentication library should be specified. Where is it located?
Christian
  • 7,433
  • 4
  • 36
  • 61
0
votes
1 answer

Move a schema from one AWS RDS to another

I need to move schema and its objects from one AWS RDS to another AWS RDS db. I have used AWS schema conversion tool (SCT) in the past. Is there any other better way or what I am doing is the best. Thank you,
Kalpesh Patel
  • 11
  • 3
0
votes
1 answer

Migrate Apache Cassandra to Amazon DynamoDB

I want to migrate the database from Apache Cassandra to Amazon DynamoDB. I am following this user guide https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/agents.cassandra.html When I try to create a clone data centre for extraction…
Talha nousher
  • 21
  • 5
0
votes
1 answer

AWS Redshift failed connect [Error setting/closing connection: Connection timed out]

Overview I learn to migrate an Amazon RDS for Oracle Database to Amazon Redshift referring this tutorial https://docs.aws.amazon.com/dms/latest/sbs/CHAP_RDSOracle2Redshift.html Trouble I had a trouble the below question. I would like migrate Oralce…
Yuta
  • 43
  • 1
  • 1
  • 6
0
votes
2 answers

I would like migrate Oralce DB to Amazon Redshift with AWS SCT

Overview I learn to migrate an Amazon RDS for Oracle Database to Amazon Redshift referring this tutorial https://docs.aws.amazon.com/dms/latest/sbs/CHAP_RDSOracle2Redshift.html Trouble In step5, I use Amazon SCT to convert the Oracle Schema to…
Yuta
  • 43
  • 1
  • 1
  • 6
0
votes
0 answers

trying to convert ORACLE code into POSTGRESQL

ls_sql := (CONCAT_WS('', ' SELECT INITCAP( CASE WHEN (TRIM(STREET_NUMBER) IS NOT NULL) THEN TRIM(STREET_NUMBER)||'' '' END)|| …
Bilal Shaikh
  • 47
  • 5
1
2
3 4