More from our Blog
solution-design, database-migration, modernization roadmap, Ora2Pg, Oracle to PostgreSQL migration, oracle-workload-migration, PostgreSQL, aws-sct, PowerBI, ETL
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
operational-data-management, Microsoft SQL Server, azure, database monitoring, Active Directory, devsecops, high-availability, Microsoft Azure, security, SQL Server, VMware
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
application-modernization, database-migration, Oracle to SQL Server, oracle-workload-migration, react, SQL Server, azure
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
oracle-workload-migration, solution-design, Microsoft Azure, Oracle, Oracle to SQL Server, Oracle to PostgreSQL migration, database-migration, architecture
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
database-migration, SaaS, Data-warehouse, data-lake, ETL, application-modernization, aws, Oracle to PostgreSQL migration, cloud-migration, PostgreSQL, Oracle, Improving the performance, AWS Batch, Amazon S3
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
Migration Solution Document Capturing the Project Roadmap — Part 4
Welcome to the fourth and final blog post in the overview series dedicated to our 12-step Migration and Modernization Methodology that was adopted by AWS. We started by defining workloads and examining their interdependencies, which set the stage for capturing the current architecture and designing the future state architecture as part of the first step […]
Adam Robertson
modernization roadmap, application-modernization, database-migration, cloud-migration, database-conversion, Database conversion errors, SSMA, aws-sct, AWS Schema Conversion Tool, aws-dms, architecture, QA, Code conversion
Analyzing Migration Project Efforts and Crafting the Project Plan — Part 3
Welcome to the third blog post in the overview series dedicated to our 12-step Migration and Modernization Methodology that was adopted by AWS. In our first and second blog posts, we explored the critical role of defining workloads in migration projects and laid out the process of capturing the current architecture and designing the future […]
Adam Robertson
Current and Future State Architectures — Part 2
Welcome to the second blog post in the overview series dedicated to our 12-step Migration and Modernization Methodology that was adopted by AWS. In the first blog post, we began exploring the first step of the methodology — Future State Architecture Design.We focused on the definition of a workload and outlined how categorizing system components […]
Adam Robertson
Workload Definition Shapes the Migration & Modernization Roadmap — Part 1
Welcome to the first blog post in the overview series dedicated to our 12-step Migration and Modernization Methodology that was adopted by AWS. In any migration or modernization project, it’s crucial to start with a clear understanding of the system’s components and their relationships. This is where workload definition comes into play. Defining workloads correctly […]
Adam Robertson
database-migration, Oracle to SQL Server, Oracle, SQL Server, Microsoft SQL Server, migrate to sql server
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)
aws-sct, aws, Database conversion errors, database-migration, Ora2Pg, Oracle to PostgreSQL migration, Oracle, PostgreSQL
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
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!