Stay up to date with the latest from the Knowledge Center. See all new and updated Knowledge Center articles published in the last month and re:Post’s top contributors.
Questions tagged with SQL Migrations
Content language: English
Select tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
34 results
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...
We are trying to Replicate Data from Oracle RDS to Target oracle RDS by Masking PII data For that we are following below approach:
1. Replicating data from Oracle RDS to 53 bucket by masking PII data...
We are trying to do Data transfer by masking PII data from source RDS account to s3 bucket. But we are not able to add new column using add-column, we don't see any specific errors as well. we are abl...