Questions tagged with Microsoft SQL Server

Hello all, hope you can help. We're hosting a new SQL 2016 RDS instance we'll call this the target DB. There is a 3rd party that is syncing data into the target DB on this instance using AWS's CDC...

I have created an instance of g5.xlarge with the Microsoft WIndows 2019 Server and MSSQL Server Standard 2019 AMI. When I tried to launch the instance, it failed at launch initiation with the...

How could the following error be resolved when upgrading SQL Server on EC2 from 2017 to 2019 using AWSEC2-CloneInstanceAndUpgradeSQLServer "Status": "Failed", "ResponseCode":1, "Output": "MSSQLSERVER...

It would be useful while full load is running to see in "Table Statistics" tab each table estimated progress in percentage ([target loaded rows]/[source_table_row_count]*100) based on the source table...

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...

Hi Team, I have done some Assessment reports for SQL server to RDS SQL Server and in reports everything is green but when iam connected to Target and applied the database to RDS SQL server, i am...

Hello, We are looking at using one of the AWS supplied AMI's with SQL Server 2022 Standard included. We also have a need to install older versions of SQL Server to extract data and possibly install...

We recently upgraded SQL Server from 2016 to 2022 and we had DMS tasks with CDC that was using SQL Server as a source. These tasks are now failing and if I point the endpoint to the SQL Server 2016,...

I have two DMS tasks which load to the same table (both source and target are SQL Server 2017) with different filters - the task that succeeds has this filter: ``` "filters": [ ...

I have created a new SQL user on an RDS (Not custom) database with : `USE master; GO CREATE LOGIN my_user WITH PASSWORD = 'my_password'; GO` And now I want to assign roles to them (dbcreator,...

Hi, We have one Windows instance with AWS cloud and our SQL Server is installed on this windows instance. We want to connect to the SQL Server on AWS Windows instance from our work computers but...

We have been able to connect to a Microsoft SQL Server DB using both Glue's DynamicFrame and Spark's own JDBC write option due to the Glue connection option. However, we want to move this workload to...