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
3
votes
0 answers

Metadata loading was interrupted because of data fetching issues. For details, see the log

I use AWS Schema Conversion Tool to migrate a data base source SQL Server to PostgreSQL, but the DB schema does not load and I get this error message " Metadata loading was interrupted because of data fetching issues. For details, see the log " And…
khawla
  • 31
  • 3
1
vote
0 answers

Is there a way to make AWS Schema Conversion Tool work with MacOS?

I'm using Mac OS Big Sur for development and the AWS docs mention the schema conversion tool is present for three platforms: Windows, Fedora and Ubuntu. Is there a way to make it work for mac os as well (besides installing a VM)?
Raghuveer
  • 1,737
  • 20
  • 27
1
vote
0 answers

MariaDB as destination permission required in AWS SCT

We are using AWS SCT tool to migrate Oracle database to MariaDB. We have given the required permission on Oracle database after reading from below https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.Oracle.html Haven't find…
Developer
  • 150
  • 2
  • 12
1
vote
2 answers

AWS - DMS migration missing sequence , views , routines ... etc

I a trying to do the migration for our Postgres database to Aurora postgres first I create a normal task it migrates all tables only except its constraints. My tries to clone our database I downloaded AWS SCT (Schema Conversion Tool) then set my…
Mina Fawzy
  • 20,852
  • 17
  • 133
  • 156
1
vote
1 answer

Modifying a refcursor from ORACLE TO PG getting error ?

FUNCTION default_refcursor RETURN SYS_REFCURSOR AS v_refcursor SYS_REFCURSOR; BEGIN OPEN v_refcursor FOR SELECT * FROM DUAL WHERE 1 = 2; RETURN v_refcursor; END default_refcursor; the above is cursor from oracle which I have to…
Bilal Shaikh
  • 47
  • 5
1
vote
1 answer

How and for what is AWS SCT useful?

I am looking to migrate some databases (in Terabytes) from oracle, MS SQL and Sybase to PostgreSQL I came across - SCT as one of the tools which might be useful I have a few questions regarding the viability and ability of SCT for the…
DevX
  • 342
  • 7
  • 16
1
vote
1 answer

how to know machine name and program name in postgresql?

select secure_decrypt_log_id_seq.nextval,**v.PROGRAM**, 'CONTRACT_PAYMENT_ID = '||to_Char(:new.CONTRACT_PAYMENT_ID), sysdate, user, **v.MACHINE**, ls_transaction_type from v$session v where v.sid = (select sid from **v$mystat** where rownum =…
Bilal Shaikh
  • 47
  • 5
1
vote
1 answer

Convert PostgreSQL function to PostgreSQL Stored Procedure

I'm migrated a schema from oracle to postgreSQL using AWS-SCT, packages are converted to functions in postgreSQL. I need to convert this function to procedure to compact with the code in the application middleware. I've tried to convert to…
aan anna philip
  • 61
  • 1
  • 9
1
vote
0 answers

Not able to configure SCT Data extractor agent for SQL Server warehouse

I am not able to configure Extractor agent for Microsoft SQL Server. I get the below error while configuring the agent: Warehouse vendor : Microsoft SQL Server AWS DMS doesn't support data warehouses from the specified vendor. Enter one of the…
Anchal Kataria
  • 11
  • 3
1
vote
1 answer

Why does AWS Schema Conversion Tool use the JAR format for for MS SQL Server?

During a demo in a recent AWS webinar, a JAR file was specified as a driver for the Schema Conversion Tool to connect to an MS SQL Server db (I am providing a screenshot from the webinar). Why was JDBC chosen? Was this optional, and was a choice…
Sabuncu
  • 5,095
  • 5
  • 55
  • 89
1
vote
2 answers

AWS SCT error while connecting to Teradata

I am trying to connect AWS SCT to Teradata to migrate some tables to Redshift. However, while connecting to Teradata, I am getting the error which says - "The specified account does not have sufficient privileges for working with the following…
Rishabh Dixit
  • 115
  • 4
  • 16
1
vote
0 answers

Can't connect to Amazon Aurora (MySQL) with AWS Schema Conversion Tool

I am having difficulty establishing a connection to my database on AWS. Making the Instance publicly accessible didn't change anything nor was changing the Security Group's inbound to accept any IP coming from MYSQL/Aurora. Here's the error coming…
Yamil
  • 11
  • 2
1
vote
1 answer

Can the AWS Schema Conversion Tool Connect to Azure

I am trying to migrate a database from a Microsoft SQL Server on Azure to an Amazon Aurora Database on AWS. Amazon provides a tool called the AWS Schema Conversion tool that is supposed to be able to convert a Microsoft SQL schema to Amazon Aurora.…
tayopi
  • 295
  • 5
  • 15
0
votes
0 answers

Preserve case sensitivity while convert schema in AWS schema conversion tool

I am converting my SQL server database schema to postgre sql schema using aws sct tool. However after running "Convert schema" option the scripts generated are case insensitive or have been converted to lower case. Is there any rule or option that I…
Swaroop
  • 501
  • 5
  • 18
0
votes
0 answers

MSSQL permission issue for AWS schema convertion

Trying to connect from AWS schema conversion tool to MS SQL in AWS cloud. In the process got the below error 2023-02-15 18:15:16.742 [ 53] LOADER ERROR Error executing 'get-log-shipping' query:…
luckyluke
  • 642
  • 2
  • 7
  • 22
1
2 3 4