AWS Schema Conversion Tool: General Approach to Migration of Data Warehouses to Amazon Redshift
06 Dec 2016

This post continues our video blog series on the AWS Schema Conversion Tool (SCT). In our previous blog posts, we talked about using AWS SCT for transactional database migration projects. The AWS Schema Conversion Tool also supports migrating data warehouse (DW) workloads to Amazon Redshift. AWS Schema Conversion Tool uses a different approach to DW migration projects compared to the transactional database migration workflow. With transactional databases, you typically have stored procedures, triggers and other database objects which deal with […]

SSMA for Oracle 7.0 — Overview of Data Migration Features
05 Dec 2016

DB Best uses a 12-step migration process to make sure all bases are covered as part of a typical migration project. Data migration is a critical part of a database migration projects and tools like SSMA can help in the process. In the following video, we will show you how to migrate data from Oracle to SQL Server using the SSMA tool, as well as highlight errors that may occur during database migration.   Need help getting started? Check out […]

Countdown to AWS re:Invent – Come see us at booth #236
21 Nov 2016

AWS re:Invent 2016 is just days away, and DB Best is excited to be there November 29 – December 2. We’ll be at booth #236. Come see us! To help start the conversation, here is a list of our recent AWS Schema Conversion Tool blog posts: Migrating an Oracle to MySQL Database using the AWS Schema Conversion Tool AWS Schema Conversion Tool: Offline Mode AWS Schema Conversion Tool: Connecting to Oracle Source Database Selecting target database type for migration using […]

AWS Schema Conversion Tool: Applying Converted Code to Target Database
16 Nov 2016

This continues our video blog series on the AWS Schema Conversion Tool (SCT). After connecting to the source database and troubleshooting the database migration issues it’s time to apply converted code to the target database. The AWS Schema Conversion Tool provides two ways of applying changes to the target database. The first option allows you to generate the SQL-script. You can modify this script if needed and then execute it using your favorite database tool. The second option allows to modify the target […]

DB Best upgrades a leading telecom company’s SQL Server 2000 and 2005 databases
11 Nov 2016

Upgrading SQL Server can be a complicated and nuanced operation, it can’t be simply performed with a few mouse clicks. In many ways, upgrading SQL Servers follows a similar process to more general database migration projects. Because of the similarities, we can apply our 12-step database migration methodology to great effect. From analyzing the existing database architecture to consolidating resources for operational cost reduction, DB Best has the tools and know-how to ensure your SQL Server platforms are up to […]

Innovation in Loyalty Programs: Augmented Reality Mobile Application for Discount Offers
10 Nov 2016

People enjoy the money-saving rewards of discount offers. On top of that, people enjoy the fun of playing games. With Reward Hunter from the DB Best app development team, mobile phone users can get the best of both worlds. At DB Best, we’ve combined these two activities into one augmented reality mobile application that can engage users and help you grow your business. This fun new application, called Reward Hunter, comes in an “out of the box” version for use on either iOS or Android mobile phones. Reward Hunter can […]

Faster reporting and flexibility using SSIS and SQL Server
DB Best Case Study: Faster reporting and flexibility using SSIS and SQL Server to offload Excel reports from SSAS cubes
03 Nov 2016

DB Best recently completed a complex development project for one of the largest banks in the Middle East. Faced with non-customizable and slow-to-generate reporting, the customer contacted DB Best to develop a new and improved solution. The customer’s original system was built on two SQL Server Analysis Services systems, each containing large amounts of various aggregated data types with Excel workbooks directly accessing the two SSAS cubes. Not only did this system take a considerable amount of time to generate […]

SSMA for Oracle 7.0 — What’s New — Using In-Memory OLTP in SQL Server 2016
14 Oct 2016

This continues our video blog series about new features on the new capabilities of SQL Server Migration Assistant 7.0. SQL Server 2016 In-Memory OLTP significantly improves OLTP database application performance and allows running large queries against the same tables using clustered and non-clustered columnstore indexes. This technology was introduced in SQL Server 2014 and now SSMA 7.0 supports migrating Oracle Database In-Memory tables to In-Memory OLTP with SQL Server 2016. Background on SQL Server In-Memory OLTP and Oracle Database In-Memory […]

Database Compare Suite 4.5 Released — Amazon Redshift and SQL Server 2000 support
12 Oct 2016

We are proud to announce the latest version of the Database Compare Suite tool, which now adds support for Amazon Redshift and SQL Server 2000. For customers looking to upgrade their SQL Server 2000 database servers, Database Compare Suite is the only tool on the market that supports comparing database schema and data changes with newer versions of SQL Server. This a great timesaver for your upgrade projects! Eight database dialects are now supported in Database Compare Suite. They include: […]

Converting Objects during Database Migration using AWS Schema Conversion Tool
11 Oct 2016

This continues our video blog series on the AWS Schema Conversion Tool (SCT). We will demonstrate how the AWS SCT helps users convert data and code objects from Oracle database to AWS RDS for MySQL, Amazon Aurora or PostgreSQL database. Background Converting Objects is one of the most important aspects in the AWS Schema Conversion Tool application. The AWS Schema Conversion Tool allows users to convert all objects in the database, or simply select the required objects and convert them […]