abcloudz

Learn more about

Database conversion errors

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)

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

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

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

Hi there! How can I help you?