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.13
Database Compare Suite update 4.13 brings Apache Cassandra support
17 Jan 2019

We’re happy to announce the latest groundbreaking release of DB Best Database Compare Suite. The new version allows for working both with NoSQL and SQL-based databases, comparing data between them. In addition to that, Database Compare Suite update 4.13 brings several important improvements and bug fixes, including: Added the support for Apache Cassandra Provided the search option for database objects Updated the data operation properties Continue reading to discover all of the major improvements implemented in Database Compare Suite 4.13. […]

Accelerate Database Migration to AWS
Accelerate Database Migration to AWS with DB Best – Webinar Wrap Up
02 May 2018

Big thank you to everyone who attended our webinar on May 1, 2018 – Accelerate Database Migration to AWS with DB Best! Dmitry Balin and myself talked about how DB Best and Amazon Web Services (AWS) can help you improve performance and reduce costs by migrating your on-premises databases to managed Amazon Relational Database Service (Amazon RDS), to virtual machines using Amazon Elastic Compute Cloud (EC2), or database warehousing solutions such as Amazon Redshift. I also did a couple 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.

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

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

Building an Ultimate Cloud-based Business Intelligence Solution for Agriculture
05 Jun 2017

One of the largest North American agricultural enterprises has been envisioning and designing a new cloud-based Business Intelligence and Data Warehousing architecture. They were using a fragmented system, based on Oracle database, while the reports were presented as a mix of SQL Server Reporting Services (SSRS) and Excel dashboards. We came up with a solution that allowed to consolidate all reports with Power BI dashboards. In addition, we proposed to migrate the original database to Azure Synapse Analytics (previously Azure […]

Using AWS Schema Conversion Tool Extension Pack for Data Warehouses
28 Apr 2017

When migrating to Amazon Redshift, you need a way to convert functions and other capabilities that Oracle, Teradata, Greenplum, Netezza support that Redshift does not natively support. The AWS Schema Conversion Tool Extension Pack for Data Warehouses provides Python based libraries to provide the same functionally with Redshift. In this post, we will show how the AWS Schema Conversion Tool (SCT) generates the extension packs to help in your migration effort. You will have to upload the extension pack for your source […]

Extracting Data from Warehouses with Data Migration Agents in AWS Schema Conversion Tool
15 Mar 2017

Migrating data warehouses to Amazon Redshift represents a serious challenges when you consider what it takes to transfer huge amounts of data in parallel. On February 16, 2017, Amazon released version 1.0.600 of AWS Schema Conversion Tool (SCT). This release brings the support of Data Migration Agents. Now you can effectively extract data from Oracle and Teradata data warehouses and prepare it for use with Amazon Redshift. In the following video, we will demonstrate the typical workflow of using the […]