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!
More from our Blog
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 cloud migration best practices.To illustrate this methodology in detail, we’ve created a series of four blog posts, each covering a critical phase of the migration […]
Latest posts
- Application Modernization
- Cloud Migration
- Consulting
- Data Warehouse Migration
- Database Consulting
- Database Migration
- Modernization
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 of the methodology — Future State Architecture Design. Next, we focused on gathering and analyzing project artifacts to inform a detailed effort estimation and project […]
- Application Modernization
- AWS Database Migration Service
- Cloud Migration
- Consulting
- Data Warehouse Migration
- Database Consulting
- Database Migration
- Microsoft SQL Server Migration Assistant (SSMA)
- Modernization
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 state architecture as part of the first step of the methodology — Future State Architecture Design.This provided a solid foundation for understanding the scope and […]
- Application Modernization
- Cloud Migration
- Consulting
- Data Warehouse Migration
- Database Consulting
- Database Migration
- Future-State Architecture Design
- Modernization
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 into specific workloads provides a solid foundation for the entire project. However, workload definition is just one part of the broader Future State Architecture Design […]
- Application Modernization
- Cloud Migration
- Consulting
- Data Warehouse Migration
- Database Consulting
- Database Migration
- Modernization
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 sets the stage for the entire project, making it possible to scope, assess, and plan each step with precision. Workload definition is one of the […]
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 high cost of Oracle licenses, the company decided to gradually retire their Oracle servers and migrate to SQL Server. They reached out to ABCloudz for […]
- Amazon Web Services
- Cloud Migration
- Database Consulting
- Database Migration
- Oracle Database
- PostgreSQL
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 constructs efficiently. In these cases, manual adjustments and optimizations are required to ensure a seamless transition to the target database. At ABCloudz, our team has […]
- Database Migration
- Microsoft SQL Server
- Microsoft SQL Server Migration Assistant (SSMA)
- Oracle Database
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 optimal results, and understanding how to overcome these limitations is crucial for a successful migration. At ABCloudz, we’ve encountered these challenges firsthand. Through our experience, […]
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 unexpected behavior in the database. This post will explore key nuances and demonstrate how to handle these differences effectively. Comparing null and empty string In […]
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. This blog post outlines a solution to handle such situations by utilizing composite data types to bypass the argument limit, ensuring routine compilation without significant […]
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 of Date and Time Conversion functions, after it was generated by SSMA. Key differences between Oracle and SQL Server Oracle and SQL Server handle date […]
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 functions correctly post-migration. For example, consider the following transformations: Oracle PostgreSQL SELECT sysdate FROM dual; SELECT aws_oracle_ext.sysdate() SELECT to_char(sysdate, ‘dd.mm.yyyy hh24:mi:ss’), to_char(sysdate, ‘dd.mm.rrrr’) FROM dual; […]
At ABCloudz, we are thrilled to announce that we have achieved the Google Cloud Non-Profit Expertise designation. This significant milestone underscores our commitment and proven capabilities in delivering tailored cloud solutions for non-profit organizations, helping them amplify their impact while optimizing resources. What does this expertise mean? Attaining the Google Cloud Non-Profit Expertise is a testament to our deep understanding of the unique challenges faced by non-profits and our proficiency in leveraging Google Cloud’s powerful tools to address those needs. […]
Our client, a global biotech company with a presence in over 80 countries and a workforce of 4,000 employees, depends on a complex IT environment that includes both on-premises and cloud-based components. This infrastructure supports everything from research and development to manufacturing and corporate operations, with SQL Server playing a pivotal role across various environments. Given the scale and criticality of their operations, the client required a partner who could not only manage and optimize their existing SQL Server infrastructure […]
- Business Intelligence & Big Data
- Cloud Migration
- Customer Stories
- Data Warehouse Migration
- Microsoft Azure
ABCloudz recently completed a significant project migrating an Enterprise Data Warehouse (EDW) from an on-premises SQL Server 2014 to Azure Databricks for a leading global retailer operating 3,000 offline stores across 40 countries. This migration was essential for addressing physical server limitations and outdated technology that hindered data processing and storage capabilities. Embracing Big Data capabilities, our solution leveraged Azure Databricks to enhance the client’s data scalability and processing efficiency, directly impacting their ability to manage and analyze large data […]