More from our Blog

Cryptocurrency is one of the biggest trends of the decade that rapidly embraces the domain of online payments. With cryptocurrency and blockchain technology, you increase your technical capacity dramatically. Our development team could not stay aside from such trends, so they jumped into the research and experimented with the latest and greatest. As part of […]

The 2022 forecast predicts that the board games market on the global level will reach $21.56 billion by 2025. At the same time, more and more creative individuals have gotten on board with independent game designing and self-publishing. It was just a matter of time until someone would come up with the idea of creating […]

In this post we continue exploring the technical aspects of Oracle to PostgreSQL migration using AWS SCT. We were using AWS SCT build#660 to convert one of our Oracle test databases. AWS SCT provides functionalities for the most efficient migration from Oracle to PostgreSQL. However, there is a common challenge with implementing the Oracle NumToDSInterval […]

In this blog post we continue covering AWS SCT conversion issues, adding to the series where we help developers to deal with complex migration issues that can’t be automated with SCT. Today we are going to look into how SCT Build #660 addresses the conversion of statements with BULK COLLECT clause. In Oracle, you can […]

Here’s one more insight into common code conversion issues while using AWS SCT build number 660. This time, we will tell you how to convert NumToYmInterval from Oracle to MySQL. Oracle has a NumToYmInterval function that converts the provided number value of specified expressions or time units to an interval year to month literal. Usually, […]

We continue our series of common issues pertaining to code conversions with AWS SCT. This time, we analyze the peculiarities of converting REF CURSOR types from Oracle to MySQL with the help of AWS SCT build number 660. In Oracle 9i, there is the predefined SYS_REFCURSOR type, which means that defining our own REF CURSOR […]

In this post we continue exploring the technical aspects of Oracle to PostgreSQL migration using AWS SCT. AWS SCT promises a very high level of migration efforts, however it is very rare that 100% automation is achieved. In this article we’ll look into conversion of INSERT ALL statements, which are quite popular in Oracle code. […]

We’re proud to announce that ABCloudz has become an AWS Select Consulting Partner, which highlights our commitment to the AWS cloud platform, and bringing the best of this cloud platform to our clients. This great event comes with some worthy achievements – The ABCloudz engineers achieved several certifications as AWS Solution Architect Associates, others received Cloud […]

In this post we explore the technical aspects of Oracle to PostgreSQL migration using AWS SCT. We’ll look into conversion of Oracle “aliases”. We were using AWS SCT build #660 to convert one of our Oracle test databases. The challenge Oracle’s subtype declaration allows creating an “alias” for some datatype declaration, which can be re-used […]

We’d like to invite you to be a part of our fundraiser for ABCloudz UA Team. As you know, Ukraine is under the inhumane attack of Russia right now, many people left their homes, some of them do not have homes anymore…. ABCloudz Inc (former DB Best Technologies) started a GoFundMe Fundraiser to support our […]

ABCloudz is a global company. Our employees and contractors are distributed across several countries on both sides of Atlantic including Ukraine.  Due to a recent Russian military aggression, many of our colleagues in the middle and central Ukraine decided to relocate and did so. Some are still in transit, on their way to new locations […]

One of our customers runs a large Azure data center that works with Personal Health Information ( PHI). Before the client contacted us, many of their servers have been running on legacy OS and the overall infrastructure was rather disorganized. The Company’s management was concerned about potential security holes and requested to conduct a thorough […]

The Instructrr is a startup in the online fitness space. They had an idea of a web-based fitness platform where fitness instructors would directly sell their learning materials and services to the customers. A user can watch fitness streams, study materials about exercises, communicate with fitness instructors, and buy services. The company already operated in the […]

Our client is a healthcare testing and biotechnology company that quickly grew from a small antigen development lab into a large producer of various healthcare tests distributed across the U.S. The client developed a new custom device for some of the most rapid COVID-19 tests. It includes a pipette for collecting blood and a small […]

Recently, the ABCloudz team migrated a customer’s database from Apache Cassandra to Amazon DynamoDB. As part of this project, we needed to run multiple tests to ensure perfect quality for our delivery. However, we faced a problem in setting up the test environment. Even though we were using AWS CloudFormation templates for the EC2 instances, it was taking over 30 mins to get the dev/test environment setup. In addition, our developers couldn’t run parallel regression testing. So, we decided to…