Questions tagged with SQL Migrations

Hi , We are doing the AWS SQL Server assessments- in the SCT report, I have received the DB Mail configuration not fully supported in AWS and suggesting the use of the SNS services. Can we can use...

Hi all, As part of our DR plan, we'd like to setup AWS DMS service with MSSQL 2019 SE RDS Cloud DB as source and MSSQL 2012 SE On-premise DB instance as our target to replicate changes from RDS MSSQL...

Hi Team , We are doing an assessment for SQL Server to RDS SQL server using SCT. can I hide(exclude) the system databases( master, MSDB, Model, Report server databases) from assessments report. As...

I have set up the DMS fleet advisor and ran the recommendations for the SQL server. It gave me Target recommendations. but I have confused about target recommendations. 1. Initially I ran the...

We have SSIS running in a RDS instances. One of the DB Connection Manger in the SSIS workflow is to an Actian PSQL database. For the connection manager to work we need the PSQL-AdoNetDataProvider4.3...

Hi guys, hope you are well! I need help with a query in athena to get my data for the previous month. In sql I used a query that worked very well and in athena I'm not getting it. My field is coming...

In the Support Docs i see that "Import Column and Export Column transformations and the Script component on the Data Flow Task aren't supported." Also can see a list of the Control Flow tasks tasks...

In trying to migrate my RDS database from EC2 to VPC, i need to to a native backup. But sql server 2008 R2 build 10...... is not available as a choice for adding options etc.

HIVE_CURSOR_ERROR: Unexpected end of input stream This query ran against the "covid_dataset" database, unless qualified by the query. Please post the error message on our forum or contact customer...

We encountered an xml issue during the poc of babelfish migration, how to rewrite a user define function based on 64-bit encryption that is very common in sql server. The following code you can find...

We are evaluating Babelfish migration from SQL Server but would like to know does IAM authentication works with Babelfish? Any guidance would be greatly appreciated.

How can I get started with migrating to Babelfish for PostgreSQL from SQL Server, and obtain the training, tips and tricks needed to be successful with my migration?