abcloudz

Learn more about

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

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?