Using data extraction filters for smart database migration with AWS Schema Conversion Tool
29 Jun 2017

Amazon introduced the data extraction agents in the previous release of AWS Schema Conversion Tool (SCT). They allowed for migrating all the data from your on-premises data warehouse platforms to Amazon Redshift. Wait, what if you don’t need to move all those terabytes of data, and just want to settle for the data generated in the past couple of years? Starting from the version 1.0.603, SCT allows filtering the data before uploading it to Redshift. In addition, the latest SCT […]

Integrating SQL Server data warehouse to improve operational efficiency
Data warehouse integration to embrace data analytics
27 Jun 2017

Our customer has been supporting Oracle based online transaction processing (OLTP) system. They decided to take advantage of the modern data analysis capabilities of SQL Server’s data warehouse features including columnstore for greater value over an Oracle based data warehouse solution. We came up with a comprehensive solution on extracting and transforming their source data and loading it into the target database. As a result, our customer benefited from obtaining a highly standardized and easily manageable solution within a short […]

Is In-Memory OLTP a Useless Feature?
22 Jun 2017

What makes a feature useless? I might agree that if absolutely NO ONE uses it, or has ever used it, then it is useless, by obvious definition.  But if some people use it, but not everyone, is that useless? What if only 1% of product users employ a feature in production? Is that useless? What if those 1% base their entire production system around the feature? Is that more or less useless than another feature used by 80% of the […]

Building detailed modernization roadmap for outdated databases using DBMSys
How the detailed modernization roadmap helped reduce the number of servers in the data center by 96%
22 Jun 2017

A major American provider of global eCommerce solutions was looking for a way to upgrade their extensive data processing system. We provided them with visibility into their system and built cost-effective and highly optimized modernization roadmap using our DBMSys Platform. Using our detailed instructions they can substantially cut the upgrade expenses and take advantage of their workloads migration to Azure along with benefits from virtualization and consolidation options.

Delivering expert support in resolving database conversion errors
21 Jun 2017

One of the major United States universities has been migrating their complex data managing system from Sybase to SQL Server. They used SQL Server Migration Assistant for Sybase to automate the migration process. However, SSMA tool could not deal with 100% of their source code, and their development team required some assistance with a manual conversion. So they asked us to provide technical support in resolving these conversion errors. With our guidance and extensive support, our customer was able to complete the migration within the short […]

An ultimate approach to converting hierarchical queries from Oracle to SQL Server
Helping our customer to convert Oracle schemas with hierarchical queries to SQL Server
20 Jun 2017

One of the world’s largest information technology companies decided to migrate their Oracle database to SQL Server. They leveraged SQL Server Migration Assistant (SSMA) for Oracle to automate the major part of their migration effort. However, their source database code included over 400 hierarchical queries that SSMA could not convert. Neither could the customer’s technical staff. So, they turned to DB Best asking for assistance in converting a number of Oracle database schemas. We helped our customer to solve this […]

AWS Schema Conversion Tool
Oracle to PostgreSQL migration with AWS SCT: How to convert INSERT ALL statement
19 Jun 2017

In Oracle you may use the conditional insert clauses, for example, an INSERT ALL statement to add multiple rows with a single command. You can insert rows into one table or even multiple tables using just one SQL statement in Oracle. However, PostgreSQL doesn’t support such statements that attempt to inserting multiple rows. So, when you try to convert the source Oracle code that includes the INSERT ALL statement to PostgreSQL in the AWS Schema Conversion Tool, it will generate the following […]

Oracle to Azure SQL Database shift may save up to $1 million
16 Jun 2017

‘Low-performing and costly’ — these were major characteristics of the Oracle system of one of our customers, a leading US automotive corporations. In this regard, it was quite natural for them to consider migrating to another database platform. We suggested changing their Oracle Database to Azure SQL Database and moving their applications to Azure services. However, the customer may well anticipate this Oracle to Azure migration solution. Why? Because according to the calculations made by our experts, they can save […]

Oracle to PostgreSQL database migration and unification project
Using PostgreSQL in cloud alongside with Oracle to enhance the database system performance
15 Jun 2017

One of the leading independent software vendors in educational domain needed to expand their original Oracle database system. They wanted to add a new PostgreSQL database running on AWS RDS to their original system and upgrade the connected Java application to support both database platforms. We came up with a proof of concept and converted one of the largest customer’s database schemas to PostgreSQL, demonstrating how the upgraded system might work. To do so, we updated the application by adding […]

Oracle to SQL Server migration with SSMA: How to convert virtual columns
14 Jun 2017

Oracle allows you to specify virtual columns in the table definition. Oracle doesn’t store the data in virtual columns on the disk. On the contrary, the database derives the values in a virtual column on demand by computing a set of expressions or functions. The computed columns in SQL Server are considered as a direct analog of Oracle’s virtual columns. The problem is that the SQL Server Migration Assistant (SSMA) for Oracle converts the virtual columns as a DEFAULT expression. Thus the logic that stands behind the […]