Need support for your remote team? Check out our new promo!*
*Limited-time offer applies to the first charge of a new subscription only.
10 licenses for the price of 3
40 licenses for the price of 10
Azure do not support Oracle DB yet, right?
Incorrect. They have been Supported for quite a while.
They made an announcement back in 2013 that Oracle will be supported on Hyper-V which paved the way to Support on Azure.
I can't even find the "offical" annoucment link anymore but found this one:
Never done it but assume it would be just like migrating a database to any other server.
There are several ways. Cannot say which one is "best" for you.
I would start here:
/SQL, trigger, function and trigger all migrate to the cloud using tools you mentioned above?
I've not seen a tool that ports code across databases. Even if a tool exists, I wouldn't suggest one. You write code in the database that should be efficient for the database. Many times what works well in one product doesn't work well in another.
I have used DMA (Database Migration Assistant) to find out incompatibilities while migrating from on-premises to Azure SQL.
my case was different, as there were lot of incompatibilities between the two environments (IaaS and PaaS),
there were mistakes that I found in existing architecture,
we were using SSIS in SQL Server but we are now using ADF in Azure.
SQL Server and Azure both are different environments, and the differences is the irony, I am not sure how Oracle differs with Azure, but there will be differences for sure as both are different products.
We created pipelines in ADF, we didn't migrated the SSIS as-is.
DMA can help to migrate, but we didn't used it due to issues in our case.
we are now using ADF in Azure.
There were some logging and data loading logic errors that need to be corrected
Yes, DMA can
. We didn't wanted to continue with SSIS as it's getting outdated, so we chose ADF
. Yes you can if you wish to
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.
Take hold of your future.