Questions tagged with SQL Migrations
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
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...
0
answers
0
votes
236
views
asked a year agolg...
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...
1
answers
0
votes
367
views
asked a year agolg...
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...
1
answers
0
votes
302
views
asked a year agolg...
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...
1
answers
0
votes
336
views
asked 2 years agolg...
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...
0
answers
0
votes
141
views
asked 2 years agolg...
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...
1
answers
0
votes
275
views
asked 2 years agolg...
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.
1
answers
0
votes
285
views
asked 2 years agolg...
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...
1
answers
0
votes
1111
views
asked 2 years agolg...
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...
1
answers
1
votes
354
views
asked 2 years agolg...
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.
1
answers
0
votes
361
views
asked 2 years agolg...
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?
1
answers
2
votes
636
views
asked 2 years agolg...
We are running DMS task which is ingesting from the on-prem mssql table with over 200mil records and has LOBs in it. Ingestion takes ~ 33 hours
On-prem DB has a backup that happens after midnight and...
1
answers
0
votes
3214
views
asked 2 years agolg...