More from our Blog
Use caution when mapping Oracle data types for procedures and function parameters in SSMA
Mapping Oracle data types to SQL Server data types is often a problem during Oracle to Microsoft SQL Server database code conversions. A tried and trusted solution is to use an SQL Server database code conversion. Another reliable solution is to use SQL Server Migration Assistant. These solutions enable you to automate Oracle database conversions […]
Andrey Khudyakov (DB architect), Roman Muzyka (writer)
Oracle to SQL Server migration with SSMA: Converting materialized view with float type
A materialized view is an important property of Oracle. SQL Server recreates the same behavior as this materialized view in several ways. Unfortunately, SSMA may have issues with converting this object to SQL Server. It flags certain conditions as an error. In this blog post, we will overview the error O2SS0522. It goes about cases in […]
Andrey Khudyakov
Migrating from SAS to Big Data for a global retailer
When a global retailer in the beauty industry needed a new and cost-effective data processing solution, they knew the search would require a high level of expertise. That is why they decided to seek advice from ABCloudz. The company had a massive amount of data and utilized SAS software for data processing, both powerful but […]
Andrey Khudyakov (DB architect), Roman Muzyka (writer)
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 […]
Andrii Koval
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 […]
Andrii Koval
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 […]
Roman Muzyka, Andrey Khudyakov
Ready to start the conversation?
ABCloudz emerged from the world of data and established itself as a go-to partner for any IT needs. Our professionals are ready to help. Drop us a line today!
