abcloudz

Learn more about

SQL Server

Oracle to SQL Server migration with SSMA: Converting interval expressions

Oracle databases have many specific functions and features. For example, it stores a period of time with specific interval expressions. This may cause issues during the database migration from Oracle to SQL Server. When you use SQL Server Migration Assistant (SSMA) for converting Oracle with interval expressions, you will observe the O2SS0006 error message. This may happen because that SSMA does not […]

Modernizing advanced engineering application from Oracle to SQL Server

Proprietary database features often create significant obstacles for developers. To demonstrate as an example, we will take a look at one of Oracle’s most valuable proprietary features – Oracle Call Interface (OCI). It ensures efficient communication between the database and the application code. Surely, you may use other options for connecting to Oracle. However, once […]

How to define a naming convention in Oracle to SQL Server migrations

Defining a naming convention for the conversion of packaged procedures and functions is a very important step during migration of Oracle database to Microsoft SQL Server. Experienced architects usually point out that this step is as significant as setting schema and data type mapping. Naming convention should be defined at the beginning of the migration […]

12 sure steps to SQL Server upgrade success 

Database migration to Microsoft SQL Server 2019 brings your software data management to a new level. It makes your application more secure, scalable, and customizable. Unfortunately, 44% of digitized businesses state that the lack of technical understanding is one of the main obstacles to successful database modernization. How can they overcome this problem? The solution […]

Improving SQL Server statistics update: How do you make it 1000 times faster than traditional approaches?

One of our clients contacted ABCloudz to request help with their SQL Server app’s performance issues. They upgraded from SQL Server 2008 R2 to SQL Server 2019 and began experiencing problems shortly after. We analyzed their database system and discovered a complex issue with updating SQL Server statistics. These stats are used by the Query […]

Hi there! How can I help you?