abcloudz

Solution design for banking system migration

When it comes to complex database migrations, especially for mission-critical systems in the financial sector, cutting corners in the early stages can turn into an expensive gamble. Yet, we often encounter organizations that view the discovery and solution design phase as an optional step — one they can skip or downsize to save time or […]
Oleksii Svitlychnyi

Managing data behind financial operations

In the financial industry, reliable data management is crucial. Downtime or performance issues are not just IT inconveniences; they can seriously disrupt daily operations. This reality was especially clear to one of our clients, a U.S.-based credit union serving public service professionals, including first responders. With a mission rooted deeply in community safety and resilience, […]
Oleksii Svitlychnyi

Performance upgrades in PostgreSQL 17

PostgreSQL continues to be the database of choice for applications demanding high performance, reliability, and scalability. The release of PostgreSQL 17 further reinforces these capabilities, bringing a series of targeted performance enhancements that directly address common pain points — reducing memory usage, optimizing complex queries, and accelerating data scanning.  In this post, we’ll dive into […]
Oleksandr Polyvanyi

JSON upgrades in PostgreSQL 17

PostgreSQL 17 significantly expands its JSON support, empowering developers to work effortlessly with semi-structured data directly within SQL. In this article, you’ll discover how the new JSON_TABLE() function and extended JSON Path capabilities simplify data extraction, transformation, and filtering, making JSON in PostgreSQL feel like a first-class relational citizen.  Whether you’re dealing with deeply nested […]
Oleksandr Polyvanyi

Incremental backups in PostgreSQL 17

Effective database backups are crucial for protecting data integrity and ensuring swift recovery. PostgreSQL 17 introduces a significant upgrade in the form of incremental backups, providing a faster, storage-efficient alternative to traditional full backups.  In this article, you’ll not only learn how incremental backups work in PostgreSQL 17 but also discover why they may completely […]
Oleksandr Polyvanyi

Modernizing an enterprise marketing system

As businesses grow, their systems must evolve to keep pace. The company at the heart of this project had built its foundation on a legacy marketing system that managed contracts, inventory, and logistics across multiple locations. The company operates in the agricultural sector, processing and distributing a wide range of products across various markets. With […]
Oleksii Svitlychnyi

Press Release: ABCloudz's Oracle Workload Migration Solution Now Available in the Microsoft Azure Marketplace

Microsoft Azure customers worldwide now gain access to ABCloudz’s Oracle Workload Migration services to take advantage of the scalability, reliability, and agility of Azure to drive application development and shape business strategies. ABCloudz, a global leader in data migration and modernization, today announced the availability of its Oracle Workload Migration offerings in the Microsoft Azure […]
Adam Robertson

Modernizing the Oracle ODS Data Warehouse for SaaS flexibility with PostgreSQL on AWS

Imagine trying to keep up with the evolving needs of higher education institutions while ensuring your systems are cost-effective and scalable. This was the challenge faced by our client, a company providing a suite of software solutions for educational institutions. They needed to modernize one of their core components—an Operational Data Storage (ODS) system, which […]
Oleksii Savchenko (DB Developer), Oleksii Svitlychnyi (Technical writer)

Introduction to the 12-step Migration and Modernization Methodology

At ABCloudz, we know that a successful migration or modernization project relies on a solid foundation and a well-defined approach. Our approach is encapsulated in the 12-step Migration and Modernization Methodology, which we’ve developed and refined over 20 years of practice. It has proven so effective that it was adopted by AWS to guide their […]
Adam Robertson

Migrating from Oracle to SQL Server for a food manufacturing company

ABCloudz recently helped The Morning Star Company, one of the world’s largest producers of tomato products, migrate their Oracle database to SQL Server. The Morning Star Company operates three processing facilities in California, handling nearly 10% of the global tomato production. Their IT infrastructure included both Oracle and SQL Server databases, but due to the […]
Oleksii Savchenko (DB Developer), Oleksii Svitlychnyi (Technical writer)

Database migration with AWS SCT: Solutions for typical conversion issues

Migrating Oracle databases to PostgreSQL or MySQL with AWS Schema Conversion Tool (AWS SCT) can present a range of challenges, from unsupported data types to limitations in automated code conversion and potential performance issues. AWS SCT offers powerful capabilities to automate these migrations, but it may not always deliver optimal results or handle complex Oracle […]
Oleksii Svitlychnyi

Database migration with SSMA: Handling typical conversion issues

Migrating databases from Oracle to Microsoft SQL Server can be a complex endeavor, especially when it comes to dealing with differences in schema structures, data types, and specific SQL clauses. The SQL Server Migration Assistant (SSMA) is a robust tool designed to automate these migrations and minimize manual effort. However, SSMA might not always produce […]
Oleksii Svitlychnyi

Handling null and empty string differences in Oracle and PostgreSQL

When migrating from Oracle to PostgreSQL, one of the most important differences to consider is the treatment of null and empty string values. In Oracle, null and empty string are treated as the same entity, but in PostgreSQL, they are distinct. Failing to account for this distinction during migration can lead to logical errors and […]
Oleksii Savchenko

Handling PostgreSQL Routines with More Than 100 Arguments

When working with PostgreSQL, database developers may encounter a limitation when attempting to create routines with more than 100 arguments. PostgreSQL enforces this restriction by setting FUNC_MAX_ARGS to 100 during the server build. Although this limitation is rarely an issue, complex procedures, particularly those migrated from Oracle, may have a significantly higher number of arguments. […]
Oleksii Savchenko

Optimizing Date and Time Conversion in Oracle to SQL Server Migration

Migrating databases from Oracle to SQL Server can be a daunting task, especially when dealing with date and time data. While tools like the SQL Server Migration Assistant (SSMA) offer automated solutions, relying solely on these tools might not always yield the best performance. In this blog, we share examples of how to optimize conversion […]
Oleksii Savchenko

Ready to start the conversation?

ABCloudz emerged from the world of data and established itself as a go-to partner for any IT needs. Our professionals are ready to help. Drop us a line today!

Hi there! How can I help you?