Learn more about
Database conversion errors
Amazon RDS, AWS Schema Conversion Tool, azure, Data Connect, Data-warehouse, Database conversion errors, database-conversion, database-migration, Ellucian, ETL, higher-education, Improving the performance, Microsoft SQL Server, modernization roadmap, PostgreSQL, PowerShell, SaaS, SAS, test automation
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)
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
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