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
1 answer

I want to convert a user defined datatype from ORACLE in to a working POSTGRE user defined data?

TYPE group_opt_cov_rec IS RECORD ( n_product_version_id PRODUCT_COVERAGE_GROUP.PRODUCT_VERSION_ID%TYPE := Null n_group_id PRODUCT_COVERAGE_GROUP.GROUP_ID%TYPE := Null , n_opt_group_cost …
Bilal Shaikh
  • 47
  • 5
0
votes
1 answer

$init function's purpose in converting package for Oracle to Postgresql, using AWS Schema Conversion Tool (aws sct)

When converting package from Oracle to Postgresql, I realize that AWS Schema Conversion Tool(aws sct) always create a function with the suffix '$init' from any package with PRAGMA SERIALLY_REUSABLE. In the newly created function, there are 3 methods…
Hung
  • 1
  • 1
  • 1
0
votes
3 answers

Naming issues on Oracle Packages conversion to PostgreSQL using Aws SCT tool

I had migrated Oracle db to Aurora postgreSQL with the help of AWS SCT tool. All packages and triggers are converted as functions in PostgreSQL. My issue here is all the names are converted with a $ (dollar) symbol. for example, A package and…
aan anna philip
  • 61
  • 1
  • 9
0
votes
2 answers

Migrating MariaDB data with DMS to exclude old records and reduce RDS size

I have a MariaDB database with 1TB of data that I need to delete old records from. The total deletion numbers will left the database with less than half of it's actual size so i thought that could be simpler if i migrate to a new RDS, using DMS and…
ronssm
  • 51
  • 1
  • 9
0
votes
0 answers

Unable to call AWS-SCT converted stored procedure from SQL Server to PostgreSQL

I have a stored procedure which is converted from SQL Server to PostgreSQL using AWS SCT. Here is the procedure's code which I am unable to call. CREATE OR REPLACE FUNCTION test.sp_getnthhightesttinyintsp(IN par_nthrow_par numeric, OUT p_refcur…
Ali Mohsin
  • 3
  • 2
0
votes
1 answer

AWS Schema Converstion Tool Microsoft SQL Server driver path

I'm trying to use the AWS Schema Conversion Tool to migrate a SQL Server database to Aurora/PostgreSQL. I get asked for the Microsoft SQL Server driver path. I've downloaded the Microsoft JDBC Driver 7.4 for SQL Server. I then browse to…
Eric
  • 2,861
  • 6
  • 28
  • 59
0
votes
0 answers

AWS SCT default binding is not set for column

I'm using AWS SCT to create the schema on my target RDS. Both source and destination engines are MS-SQL. I'm able to convert and create appropriate schema on target RDS using SCT but the Default Binding is not set for columns in target RDS. The…
Roshan007
  • 658
  • 2
  • 7
  • 15
0
votes
1 answer

Difference between data extractor agents and dms agents in AWS SCT

I am bit confuse between the different kind of agents present in AWS SCT archive. I am using 1.0.624 version of SCT. agents - data extractors tool rpm dms agents - dms agent rpm As per my understanding both of them are used to extract data from…
Anchal Kataria
  • 11
  • 3
0
votes
0 answers

Conversion process hangs under AWS Schema Conversion Tool

During a recent AWS webinar, a database conversion initiated under the Schema Conversion Tool resulted in the process hanging. I am providing a screenshot below: If one encounters such a problem, what would be the procedure to debug this? Is the…
Sabuncu
  • 5,095
  • 5
  • 55
  • 89
0
votes
0 answers

Convert row_number() function for mysql ddl statement

I am trying to run the below ddl statment generated on DB2 to mysql. However, it gives me error that row_number() doesn't exist on mysql. Can someone please tell me how to emulate this in mysql ? Query CREATE VIEW "MY_PORTAL"."MyView" AS SELECT…
Naxi
  • 1,504
  • 5
  • 33
  • 72
0
votes
1 answer

AWS SCT : What Redshift data type is equivalent to SQL Server's datetime?

We're trying to migrate our DWH from current SQL Server 2016 to AWS Redshift by AWS SCT (Schema Conversion Tool). Our SQL Server tables have the columns of 'datetime'(YYYY-MM-DD hh:mm:ss.000). They are normally converted to Redshift timestamp…
Sachiko
  • 808
  • 1
  • 12
  • 31
0
votes
1 answer

Creating Create Table statements for Redshift by reading Oracle DDL statement in python

I have 5 tables in an Oracle database. I need to create similar structures of them in AWS Redshift. I am using cx_oracle to connect to Oracle and dump the ddl in a csv file. But changing that DDL for each datatype in python to make it run in…
Sourav Gupta
  • 227
  • 5
  • 17
0
votes
2 answers

AWS Schema conversion tool - Connection error

I am trying to migrate my Oracle database to an AWS Redshift cluster, and I am following the steps as documented in the AWS website. When I try to create a project in AWS Schema Conversion Tool, configured for Oracle (running in my laptop), I am…
Yuva
  • 2,831
  • 7
  • 36
  • 60
0
votes
1 answer

Can I connect local sql server database as source in AWS SCT?

I want to connect my local sql server database as source in SCT to convert it to Amazon RDS for MySQL. After Im planning to use DMS for the migration task.
adrianlp05
  • 3
  • 2
0
votes
0 answers

AWS Schema conversion in public schema Pgsql

Using AWS conversion tool I am suppose to MS-SQL conversion into PostgreSQL, Its converting but its creating new schema. I have a public schema and I need to convert into this schema only, Is there any way to select existing schema, by default its…
Md. Parvez Alam
  • 4,326
  • 5
  • 48
  • 108
1 2
3
4