Top AWS DMS and SCT blog posts
03 Aug 2020

Last updated in August 2020 Sharing our technical experience with the readers, we’ve reached a pretty impressive audience on our blog. So, it was pretty easy to distinguish the most popular AWS Database Migration Service (AWS DMS) Support stories. Let’s jump right in and review the most valuable and really important DB Best blog posts on AWS DMS and AWS Schema Conversion Tool (AWS SCT). We’ve got an impressive series of blog posts, where we talk about the features of […]

Database Compare Suite 4.12 update brings some important improvements
20 Feb 2018

We’re happy to announce the latest release of Database Compare Suite 4.12. This new version brings several important improvements and bug fixes, including: Improved User Interface Increased Application Performance Functional Innovations Continue reading to learn more about the ultimate DBA tool and discover all of the major improvements implemented in this latest application release.

AWS Snowball Edge
Using AWS Snowball Edge to transfer multiple terabytes of data into the Amazon cloud
10 Jan 2018

Managing data and applications anywhere, we often face the issues related to the migration of huge amounts of data for our customers. So, as the Amazon partner, we received the brand new AWS Snowball Edge for testing purposes and tried to migrate our Oracle Database to Amazon Aurora PostgreSQL. Check out our blog post to learn more about our experience with AWS Snowball Edge.

Amazon Redshift Performance Tuning Tips
Using Amazon Redshift performance tuning tips to reduce query times by 800%
14 Dec 2017

Often database administrators experience decreases in query performance with Amazon Redshift as the size of data increases. The problem becomes even more significant when we start talking about regularly executed queries. Design time decisions that were made with the given the statistics at the start of the project may not make sense with the new data and query patterns. So, this means that the Amazon Redshift cluster requires some optimization. See how these Amazon Redshift performance tuning tips can improve query execution […]

Database Compare Suite update 4.11 with Vertica Analytics Platform support
04 Sep 2017

We’re happy to announce the latest release of DB Best Database Compare Suite. The new version marked 4.11 brings support for Vertica Analytics Platform. Learn more about the ultimate DBA tool and discover the major updates implemented in the latest release from our blog post.

Database Compare Suite update 4.10 brings Sybase IQ support
26 Jul 2017

We are happy to announce the latest release of DB Best’s in-house tool Database Compare Suite. The new version marked 4.10 brings support for yet another data warehouse platform — Sybase IQ. Watch Database Compare Suite in action in the following video and learn more about other improvements of the latest update from our blog post.

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 […]

Database Compare Suite update 4.9
Database Compare Suite update 4.9 brings Azure Synapse Analytics support
14 Jun 2017

We’re excited to bring you the latest release of Database Compare Suite. The new version 4.9 features support for Microsoft Azure Synapse Analytics along with some other improvements. Covering 12 Major Database Platforms With the support of Microsoft Azure Synapse Analytics (previously Azure SQL Data Warehouse), the total count of available database platforms in the Database Compare Suite reached the total of 12. This dozen includes 5 specific data warehouse platforms. So, you can keep humongous data under control with […]

Using data extraction agents to fulfill the database migration projects in AWS Schema Conversion Tool
07 Jun 2017

The Amazon Database Migration Service (DMS) does a great job in helping to copy data from your on-premises databases to AWS RDS for OLTP workloads. When you start talking about terabytes of data, the prior version of DMS was not up for the job. Amazon realized the shortcoming and developed an extension to the Schema Conversion Tool to create a performant way to migrate Terabytes of data from your on-premises Data Warehouse platforms to Amazon Redshift. On May 11, 2017, […]