Oracle to PostgreSQL migration with AWS SCT: How to handle unsupported NumToDSInterval function
02 Mar 2017

Oracle’s NumToDSInterval function converts the provided number value of specified time units or expression to an interval day to second literal. Usually, we use the interval values when dealing with dates. PostgreSQL provides some support for intervals but does not support storing values of such kind in variables. Hence, there are no functions in PostgreSQL able to return interval values.We commonly use the functions working with date intervals in reporting and other type of queries. So, when you try to […]

Database migration with AWS SCT: How to handle typical conversion issues series
02 Mar 2017

Welcome to our blog post series covering the typical conversion issues of AWS Schema Conversion Tool (SCT). DBBest team has a vast experience in database migration area. So, we decided to start the blog post series covering the most common conversion issues of AWS SCT. Each blog post will be devoted to a certain action item and will provide specific solution or a workaround for a problem. Below you can find the table of contents for blog posts, related to the […]

Oracle to MySQL migration with AWS SCT: How to handle unsupported NumToYmInterval function
02 Mar 2017

Oracle’s NumToYmInterval function converts the provided number value of specified time units or expression to an interval year to month literal. Usually, we use the interval values when dealing with dates. MySQL provides a certain level of support for intervals but does not support storing values of this type in variables. Hence, MySQL does not have any functions that are able to return interval values. The functions working with date intervals are commonly used by reporting and other type of […]

Oracle to PostgreSQL migration with AWS SCT: How to handle unsupported data types
02 Mar 2017

Oracle’s subtype declaration allows creating an “alias” for some datatype declaration, which can be re-used later as many times as needed. PostgreSQL domains do not match Oracle’s subtypes completely. Thus, whenever you try to convert PL/SQL code containing variables that are declared with defined subtype, SCT will generate the following message: “Issue 5028 — Unable to convert definition of object with unsupported datatype”.   Continue reading to learn more about the possible remedies of this issue.

Oracle to MySQL migration with AWS SCT: How to convert variables of SYS_REFCURSOR datatype
02 Mar 2017

Oracle 9i introduced the predefined SYS_REFCURSOR type meaning we no longer have to define our own REF CURSOR types. We normally use Oracle’s SYS_REFCURSOR datatype to declare the CURSOR variable of a weak type, which means that we don’t know exactly the number of columns and their type. Then this SYS_REFCURSOR variable has to be used together with a dynamic SQL code to open the cursor variable. MySQL does not support cursors of a weak type. So, when you try to […]

Optimizing your Redshift Storage with AWS Schema Conversion Tool
02 Mar 2017

Amazon introduced the new feature called Redshift Optimization for the Schema Conversion Tool (SCT) November 17, 2016 release. You can now use AWS SCT to optimize your Amazon Redshift databases. For more information, see Optimizing Amazon Redshift by using the AWS Schema Conversion Tool. In the following video, we will demonstrate the essentials of using the Redshift Optimization to improve the query performance. Make sure to check out our new AWS Schema Conversion Tool Jumpstart offer to get you up […]

Using a Neural Network for Face Tracking on Android
02 Mar 2017

In one of our previous blog posts, we talked about face tracking basics. We have demonstrated a simple mobile Face Tracking application, based on native iOS frameworks. Nonetheless, it had some serious limitations and restrictions. We will now take a step forward and talk about more complex face tracking mobile application, where a neural network performs the detection of users’ faces. We should note that the implementation of neural networks in mobile applications proved to be quite a challenging task. […]

Break the Silence — Try Emojitones for Sound Messaging!
01 Mar 2017

Communication remains a very important part of our daily life. Smartphones’ usage growth allows you to stay in touch with your friends on the go. Many chat applications have already made their name in the market, for instance Skype, WhatsApp or Facebook Messenger. Nonetheless a new solution can certainly break through and find its place in the sun. Especially when it comes with some really cool and innovative features. We proudly present Emojitones, the first ever sound-based messenger in the world, developed by DB Best team. This […]

Using AWS Schema Conversion Tool for Application Conversion
24 Feb 2017

A typical database migration project includes not only the schema conversion and data migration but also the application remediation. We are talking about one or many applications interacting with the source database. To wrap up the database migration project, you will need to convert the SQL code used in the application and then reconnect it to the new database. AWS Schema Conversion Tool (SCT) helps to automate this process and simplifies required efforts estimation for manual SQL code conversion. Check the […]

Discover How Face Tracking Mobile Apps Can Improve Your Business
10 Feb 2017

Detection of human faces in real-time imaging is a common task, which may occur in different areas and fit diverse business demands. Various algorithms were developed to resolve this task, and some of these solutions can be used in mobile applications for iOS or Android. Let us take a look at an iOS application prototype, which demonstrates the implementation of the Face Detection technology in quite a simple and entertaining way. Have a look at the following video to learn […]