Questions tagged with SQL Migrations
Content language: English
Sort by most recent
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 to be installed on the RDS server.
https://esd.actian.com/product/Zen_PSQL/SDKs/ADO.NET/ADO.NET
Is this supported? If so how can i accomplish it?
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 yyyymmdd and string format.
The query that I need help for athena to understand is this one:
REF_DATE BETWEEN DATEADD(MONTH, -1,(GETDATE()1DAY(GETDATE())+1)) AND DATEADD(DAY,1,(GETDATE()DAY(GETDATE())+1)))
Thank you so much!
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 that are supported.
But wasn't clear about the "Web Service Task".
Does the RDS integration with SSIS support it?
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 support with Query Id: 4d5d4b1c-c377-4304-9698-ac61d20df887
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 on many web site
```
CREATE FUNCTION [dbo].[FnBase64Encode](@src varchar(max))
RETURNS VARCHAR(max)
as
begin
declare @bin varbinary(max)
set @bin=Convert(varbinary(max), @src)
return cast(N'' as xml).value('xs:base64Binary(xs:hexBinary(sql:variable("@bin")))', 'varchar(max)')
end
GO
```
We know that the current version of babelfish(1.2.1) does not support xml methods such as xml.node and xml.value, is there any solution or sample code for this case?
asked a year ago
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.
asked a year ago
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?
asked a year ago
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 the task is failing right after that. Below are the logs:
```
[SOURCE_UNLOAD ]D: Network error encountered
[SOURCE_UNLOAD ]D: Is connection error? TRUE
[SOURCE_UNLOAD ]D: Endpoint is disconnected [1020414] (endpointshell.c:3807)
[SOURCE_UNLOAD ]W: Error was encountered while FETCH-ing data from table ...
[SOURCE_UNLOAD ]D: Error executing source loop [1020414]
```
I haven't tried the executeTimeout in the source endpoint connection attributes yet and wanted to ask what would be the suggested option to get around the timeout on the source issue
Hi Guy I need some help / advise.
Is it possibe to install really old service portal on AWS? Apache 2.0 Handler PHP Version 5.3.3-7+squeeze9 PGSQL v. 8.4
I have to somehow take over it from the last owner and install somewhere. Just to ask you if you think it is doable?
Thanks Marta
when we are trying RDS MySQL 5.6 to 5.7 upgrade facing issue:
"MySQL 5.7 preupgrade check to catch orphan table issue, datadir or frm file was removed or corrupted"
Please help me what to do for this issue ?
and how to delete this frm file (we do not have access for directory)
I have a database on my company's AWS server. We have hundreds but I am only concerned with two. Both are hosted on AWS. One is a MS SQL server and the other a MySQL.
I need to periodically move an entire database from MSSQL *to* MySQL. They are large databases so MySQL workbench and SSIS often fail due to size. ~1-2 million records. Less than 10GB data.
I have seen mentions of an Amazon service called DMS. Is there a service on Amazon that can do this? I do *not* need a permanent connection or sync between the two. Just 3-4 times a month to move the database.
I do not want to mention this to my Workgroup until I know it can be done. Is Data Migration Service the tool I need? Are there any other AWS solutions ?