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 you have committed to OCI, switching to another interface becomes a real headache. Read our new blog post to understand how you can overcome challenges […]

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 project. Let’s discuss in detail why this step is so important and what type of issues you may experience if not defining naming convention properly. […]

Azure SQL Managed Instance (MI) is a highly-efficient Azure service that allows combining the broadest SQL Server database compatibility with numerous benefits of a fully managed PaaS (Platform as a Service). MI provides a much higher degree of capability than Azure SQL Database DTU and vCore service levels. Read this blog post to know the main reasons and implications of migrating to Azure SQL MI. Also, get to know how ABCloudz specialists can help you migrate quickly and efficiently. Why […]