Questions tagged with SQL Migrations

We’re reviewing how SQL Server Agent jobs should be scheduled in systems where workload is intermittent. In some environments, jobs are configured to run at very frequent intervals (for example every...

We are in the process of migrating to AWS and during the ready for testing we are unable to connect to a named SQL database instance. No firewalls are blocking ports 1433 or 1434. Using Data Link Pr...

I am trying to implement below scenario : suppose there are 89 records in my source table and I want to pick only 15 records and these 15 records should be picked on the basis of proportion of values...

Hi team, We are created Linked server on single-AZ RDS SQL server for Multi-AZ RDS SQL server. the Linked server some times test connection working and some time not working. we used Multi-az DNS nam...

i got backup from SQL server DB, upload file bak into Bucket S3 and tried to restore it into db on RDS with following commands: exec msdb.dbo.rds_restore_database @restore_db_name='database', @s3_arn...

Hello, I have AWS lightsail. I use Sqlite3 to fetch some data from AWS to my frontend (siteground). However, i keep getting the error: *Access to fetch at 'https://api.AAA.xyz/api/result?start=AAA&d...

We are planning to migrate our databases to Aurora, and we would like to know what the impact in our pipeline would be. We are currently running a dms task with Full load, ongoing replication that mig...

Hello, I want Synchronize aws aurora mysql database with GCP CloudSQL in case of disaster. If there is disaster so our system connect GCP CloudSQL to avoid downtime. Is there any guidelines or docs re...

Hi, I have some raw CSV data coming in from my THING. I created a rule but am having trouble parsing the data to my Dynamo DB. I can write all to one Type, but not multiple or separately. I want to...

Hi Team, We are planning to migrate the SQL Server Agent jobs to AWS RDS SQL Server and while going through the Agent related roles, i get to know we don't have similar permission as MS SQL Server. C...

We have an application, which needs to create table in system database in SQL SERVER RDS. We are getting , below error while trying to create a table. The following SQL Server error or errors occurr...

Hello, I'm currently planning a migration of our database from a Microsoft SQL Server, hosted with a third-party provider, to AWS Neptune. Given the significant differences between a traditional rela...