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 Assessment Report in AWS Schema Conversion Tool Troubleshooting database migration issues using AWS Schema Conversion Tool Assessment Report Converting Objects during Dat...

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 database in real-time, using the GUI of the AWS Schema Conversion Tool. In addition, SCT drops and recreates existing objects on the...

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 date. In the following video, we will show you how DB Best executed a SQL Server upgrade project for one of Europe’s leading tel...

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 also be customized for your business, for a unique user experience to help build your company̵...

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 reports, but the non-customizable structure proved limiting for the customer. Check out the video below to see how DB Best used SQ...