Oracle to SQL Server using SSIS
Remote migration from Oracle to SQL Server using SSIS
04 May 2017

A global financial software provider contacted us to migrate their billing solution from Oracle to SQL Server using SSIS for one of their strategic clients located at the other end of the world. They also needed to transfer data from Oracle to SQL Server using SSIS. The actual migration had to be performed by the remote team. In order to do so, our customer was looking for an automated solution with detailed step by step instructions. To meet the customer’s needs, we developed a command prompt migration utility accompanied by extensive documentation for a remote team. With our solution, the customer was able to migrate all data within the ...

Change Data Capture for SQL Server Table Replication
Using Change Data Capture for SQL Server Table Replication
06 Apr 2017

A major bank in Europe that we’ve been working with over the years requested our help in upgrading SQL Server 2008 to 2016. Since we performed the migration process originally from DB2 to SQL Server we had a deep knowledge of the customer’s data. Because of the need to have a highly available system and they could not afford to be down. Our client needed a way to downgrade to the old database system in case something bad happens to the upgraded system. Also, our customer wanted to include the disaster recovery solution. We proposed a solution that would allow them to use SQL Server table replication from the upgraded database...

Our customer reduced costs by over 20% by optimizing Azure elastic pools
29 Mar 2017

A leading provider of payroll and HR services in the United States faced the difficulties with configuring the Azure elastic pools for the needs of their SaaS Azure app. The Azure tools provided by Microsoft were not flexible enough to fine-tune the performance of 20,000 customer databases with different utilization patterns. Moreover, it was almost impossible to maintain so many databases manually. We came up with the solution that allows automatic management of the customer databases basing on extensive monitoring of elastic pools performance. Now the customer can optimize the Azure resources utilization that results in over 20 percent r...

Moving workloads to the cloud: MongoDB Cluster Deployment Automation
21 Mar 2017

An international healthcare company felt the urge to migrate core components of their application initially to Azure Infrastructure-as-a-Service (IaaS) with a long-term goal of transferring the solution to Azure Platform-as-a-Service (PaaS). We came up with a solution that automates the ‘lift and shift’ migration of their existing Linux-based MongoDB Cluster (dozens of virtual machines) to Azure IaaS. We created the cloud automation script that allows not only to deploy  the customer’s system but also to upgrade and scale it in the cloud, thus making the whole system cost-effective and improving its performance. Watch the following vid...

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...