Convert Oracle sequences
Converting Oracle sequences to Microsoft SQL Server
15 Aug 2019

In Oracle, you can use a combination of a trigger and sequence to generate unique values for the key columns. However, when migrating your Oracle database to Microsoft SQL Server, you need to find the right path to convert this construction. This is an architecture-level decision, so you need to approach it at the very beginning of your migration project. Otherwise, you will need to recreate tables, reload data and recreate backups, and even rewrite code that relates to these tables.
Read this blog post to discover our proven solution to Oracle sequences conversion.

Data comparison
Comparing data in your databases using Database Compare Suite
13 Aug 2019

At DB Best, we believe our Database Compare Suite is the ultimate solution for database developers, administrators, quality assurance, and DevOps engineers to simplify their daily routine. Until we have Database Compare Suite on every developer’s desktop, we are starting a series of mini-blog posts with short videos to hopefully convince you that you can’t live without our Database Compare Suite!
In our first blog post of the series, we will show how you can use Database Compare Suite to validate database migration.

Oracle Forms SQL statements
How to run SQL statements after migrating from Oracle Forms to web applications
09 Aug 2019

At DB Best, we’ve helped several customers move away from Oracle Forms to a modern web-based solution. To accomplish this, developed a totally new Oracle Forms Converter. This tool allows for automating the migration of your Oracle Forms to web single page applications.  In this blog post, I’ll talk about making SQL statements from Oracle Forms compatible with your new application. The problem Oracle Forms run different queries and execute SQL statements directly at the connected Oracle Database. These SQL statements are […]

Docker
DevOps and test automation: Docker saves the day!
06 Aug 2019

Recently, the DB Best team migrated a customer’s database from Apache Cassandra to Amazon DynamoDB. As part of this project, we needed to run multiple tests to ensure perfect quality for our delivery. However, we faced a problem in setting up the test environment. Even though we were using AWS CloudFormation templates for the EC2 instances, it was taking over 30 mins to get the dev/test environment setup. In addition, our developers couldn’t run parallel regression testing. So, we decided to leverage Docker to automate the environment set up.
In this blog post, we will share our experience with using Docker for automating a NoSQL database migration dev/test environment.

ongoing-development-dbbest
Why you should never stop application development?
02 Aug 2019

The application development lifecycle has 6 proven stages that lead to the application’s release. In reality, the development process never ends with the initial release. There are always brighter ideas, new features, and enhancements that take you back into the development phase. Later, these ideas become the 2.0 version of your application. That’s what we call the “ongoing development process”.

cleaning-up-sql-server
Cleaning up a disorganized SQL Server for informed business decisions
26 Jul 2019

For quite a period of time, our customer was using a SQL Server database that at the long last became disorganized and fairly difficult to arrange. The difficulties with finding and retrieving the right data negatively influenced their performance. In addition, their server was storing duplicating views and tables that utilized space. The problem Our customer considered hiring several data analysts to reinforce their team. However, extra people in the team couldn’t address the challenge for they weren’t aware of […]

naming convention
Defining a naming convention in Oracle to SQL Server migrations
17 Jul 2019

When migrating Oracle databases to Microsoft SQL Server, you need to define a naming convention for the conversion of packaged procedures and functions. This step is as important as setting the schema mapping and data type mapping. This is an architecture-level decision that you should make at the very beginning of your migration project. Read this blog post to discover the importance of this decision and the possible issues it may cause.

DBBest post about misleading ideas in SW development
Top 10 misleading ideas that don’t work in application development
16 Jul 2019

The DB Best team has been building applications for more than 10 years now. The software development path that we follow and lead our clients through is very exciting. With every new project and task, we become wiser meeting new obstacles and handling them successfully.

So, we’d like to share some key misleading ideas that slowed down both — our teams and those of our clients. Ideas that slowed the development process and delayed us from handling the additional obstacles instead of moving further and faster.

Power BI Premium limit
Reaching the limit with Power BI Premium resources
10 Jul 2019

One of our enterprise-level customers reached the Power BI capacity limit on dedicated cloud computing and storage resources. They already owned the Power BI Premium licensing package and didn’t want to spend more money to buy additional resources.
Reaching the resource capacity limit in Power BI may lead to serious consequences. Data models using this service will fail when refreshing through the gateway. The business will not get new data, causing all teams to fall behind on analysis of information.
See how you can address this issue.

Upgrade application 2019
Upgrade your mobile applications to meet the marketplace requirements in 2019
09 Jul 2019

Apple and Google set new rules for mobile applications on the App Store and Google Play annually. Even if you are not a developer, as a business person whose business is strongly associated with an application or a mobile platform, you should review them.
Read the blog post to learn more about the restrictions and updates we will face within the app market in 2019.