Learn more about
database-migration
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
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
SSMA, Database conversion errors, database-migration, Oracle to SQL Server, Oracle, Microsoft SQL Server
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 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
How to Optimize Oracle-to-PostgreSQL Migrations Using AWS SCT Extension Pack
The AWS SCT Extension Pack is designed to emulate Oracle’s system functions, procedures, and other database objects within PostgreSQL. This emulation is achieved by creating a special schema in PostgreSQL, named aws_oracle_ext, where these functions and objects are stored. This pack simplifies migration by replacing Oracle-specific calls with their PostgreSQL equivalents, ensuring that the code […]
Oleksii Savchenko
Fault-tolerant algorithm for migrations from MySQL to MongoDB
When it comes to seamless data system management, our international IT client needed a solution to migrate their client’s legacy MySQL solution to a fully-managed MongoDB environment. Our team at ABCloudz was up for the challenge and delivered a fault-tolerant algorithm that ensures the migration process is reliable and user-friendly. The need for fault-tolerance and […]
Oleksandr Gora
Sophisticated migration of an IT infrastructure from on-premise data center to the AWS cloud
ConcertAI, one of the leading providers of medical research software, faced a common scenario for a mature healthcare data center. Over the years, its infrastructure had become highly sophisticated but inconsistent. Some of the servers were running outdated, end-of-life operating systems and urgently needed upgrading. The client decided to implement a cloud-based solution for infrastructure […]
Alex Smirnov, Roman Muzyka