More from our Blog
Latest
posts
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
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 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
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
ABCloudz has Attained Google Cloud Non-Profit Expertise
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 […]
Adam Robertson
operational-data-management, database monitoring, security, SQL Server, cost-optimization, SharePoint, ETL, health check, Azure SQL Database, azure
Operational Data Management for a Global Biotech Leader
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. […]
Sergii Zymbytskyi, Oleksii Svitlychnyi
Databricks, azure, big-data, Data-warehouse, Data-platform, cloud-migration, Business-intelligence, SQL Server, Microsoft Azure, Azure-DevOps, Azure-Data-Factory, ETL, Oracle
EDW to Azure Databricks Migration
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 […]
Sergey Shtypuliak (DB Engineer), Oleksii Svitlychnyi (Technical writer)
Natural Language Interface for Data Platform
Imagine a business analyst whose task is to extract necessary information from a data warehouse to generate various reports. They need to be proficient in crafting SQL queries of any complexity—a challenging and time-consuming feat that requires deep understanding of database structures and SQL language. But what if this business analyst had an AI assistant […]
Maksym Kurhanetskyi, Oleksii Svitlychnyi
AI Text Classification and Matching for Better Decisions
Picture this: You have an AI-powered assistant that helps manage your team’s growth. It works with three types of text data: job descriptions, employee skills, and training programs. You give it a job description and an employee’s skill set, and it pinpoints the perfect training programs to bridge any skill gaps. It’s like having a […]
Maksym Kurhanetskyi, 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!