abcloudz

Learn more about

Microsoft SQL Server

Modernizing analytics pipelines with Data Connect

This post shares how ABCloudz and Ellucian helped one of the largest U.S. community college systems move from legacy SQL Server infrastructure to a cloud-native analytics platform on AWS, using Ellucian Data Connect to modernize data pipelines and integrations. We dealt with business-critical legacy procedures, manual PowerShell scripts, SQL Agent jobs, and a complete lack […]
Oleksandr Polyvanyi (Solution Architect), Oleksii Svitlychnyi (Technical Writer)

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

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

Hi there! How can I help you?