abcloudz

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

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 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

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

Excellent operational data management to support a complex data infrastructure

According to Business Insider, a single minute of data infrastructure downtime in a data center costs the companies using this data center over $8,000. The more complex your data infrastructure is, the greater the risk of errors that can lead to downtime, compromised data quality, or disruption of vital processes. The challenge lies in the […]
Sergii Zymbytskyi

Developing Low-Code App Builder

Imagine launching healthcare apps in a snap, with minimal coding required. That’s the promise of our latest innovation—a low-code platform specifically designed for the fast-paced world of healthcare. Developed for a leading pharmaceutical enterprise, it’s a game-changer in custom healthcare application development, catering to an array of treatment requirements with unprecedented ease and flexibility. The […]
Konstantin Maevskiy

Get maximum of SQL Server: comparing Azure SQL Database and SQL Server on virtual machines

SQL Server is a veteran in the data management market and Microsoft’s most popular relational database management system. It boasts several benefits, including fast query processing, excellent security and data restoration, easy integration with other database systems, portability, and a variety of tools and plugins to enhance database management efficiency. Moreover, migrating SQL Server to […]
Sergii Zymbytskyi

Feng Shui, VMWare, and SQL Server – Finding Balance

Feng Shui is the practice of arranging pieces in living spaces to create balance with the natural world. VMWare vSphere virtualization has grown since its introduction in 1998, to being the top virtualization technology in use by companies today, holding 23% of the market. Microsoft’s SQL Server product, first released in 1988, has increased its […]
Thomas Roehr

License inventory for a large SQL Server database infrastructure

Here’s a new entry to our series of posts on how the ABCloudz team has helped a large pharmaceutical company manage its sophisticated data infrastructure. The customer’s business is rapidly growing, which leads to a significant expansion of their data infrastructure. This infrastructure has exceeded 140 SQL Servers united by complex connections and ETL scripts. […]
Zymbytskyi Serhii

How to cover monitoring gaps for a large SQL Server data infrastructure

Our client is a large pharmaceutical company with a sophisticated data infrastructure. Along with the company’s rapid growth, its data infrastructure started growing as well. At one point, their data infrastructure exceeded 140 SQL Servers united by multiple scripts and connections. This growth made its maintenance more challenging and time-consuming. The customer created a professional […]
Zimbitskiy Serhii

Market review: SQL Server Monitoring Tools

It’s no secret that a modern world runs on data. This essential asset is stored in databases or data stores. And keeping such databases or data stores healthy is vital in the digital era we live in. It is also no secret that database issues can take down entire systems and cost businesses many thousands […]
Sergii Zymbytskyi, Roman Muzyka

Quick and easy automatic approach to database conversion

One of the largest educational organizations in the United States had been running their data handling system in the Oracle environment. They wanted to reduce maintenance costs due to the expensive Oracle licensing model, which includes an additional fee for the partitioning feature. The ABCloudz team provided a solution for migrating the customer’s database to […]
Andrey Khudyakov, Roman Muzyka

An overview of the remote migration from Oracle to SQL Server with SSIS

One of our clients, a large financial software company, wanted to migrate their billing solution from Oracle to SQL Server. They needed to initiate this project because the migration was required by one of their strategic partners. The customer decided to implement SQL Server Integration Services (SSIS) for this migration. Additionally, they needed to do […]
Andrey Khudyakov, Roman Muzyka

Conversion of Oracle schemas with hierarchical queries to SQL Server

One of our clients, prominent information technology company, needed to migrate its Oracle database to SQL Server so they called ABCloudz. They knew they wanted to automate the major part of the migration with SQL Server Migration Assistant (SSMA) but there were some challenges associated with this process. First, the company’s source database code contained […]
Andrey Khudyakov (DB architect), Roman Muzyka (writer)
12

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?