AWS documentation highlights several different methods for migrating Oracle database data to AWS. In addition, AWS published a white paper titled Strategies for Migrating Oracle Databases to AWS last updated August 2018. The solutions that AWS offers fail to address lift-and-shift scenarios for large databases requiring near-zero downtime when switching over from on-premises to AWS. In this paper, we describe the steps we took for our customer using Oracle Data Guard to perform the synchronization needed for near-zero downtime between […]
Microsoft ends the extended support of SQL Server 2008 and 2008 R2 on July 2019. With the deadline rapidly approaching, upgrading your legacy SQL Server workloads as soon as possible is crucial. Thanks to our experience with prior customers, we’ve determined that up to 80% of SQL Server 2008 instances can upgrade directly to SQL Server 2017 with no application changes. Moreover, we created a SQL Server upgrade checklist, which is based on the best practices that we discovered from these customer’s projects. Rather than […]
DB Best goes well beyond other migration service providers. We take a vested interest in your migration strategy, combining innovation with an accelerated ROI that meets your business needs. The Database Migration projects are usually part of larger application modernization efforts. DB Best realizes that no two database migration projects look the same. Learn from our eBook how DB Best can provide you with a variety of choices including retiring the application, multiple levels of interoperability, just moving the data, or […]
A major American provider of global eCommerce solutions was looking for a way to upgrade their extensive data processing system. We provided them with visibility into their system and built cost-effective and highly optimized modernization roadmap using our DBMSys tool. Using our detailed instructions they can substantially cut the upgrade expenses and take advantage of their workloads migration to Azure along with benefits from virtualization and consolidation options. Check out our eBook to learn how we helped our customer.
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. Check out our […]
A major Health Department was running a data system that has been expanding over the years. Eventually, they ended up with highly outdated and inefficient environment with thousands of Microsoft Access and SQL Server databases. Such outdated system presents a number of risks such as performance, scalability, manageability, security issues and frequent database corruptions. This leads to revenue losses because of poor performance. Moreover, such environments are usually not cost-effective with increased operational expenses due to a great number of […]
One of our public sector customers was using a distributed SQL Server 2016 database system and was considering an upgrade to unite the servers in one data center, or even a move to the cloud. We helped them by using our DBMSys service to perform the overall database health check. As part of the database health check, we found several high priority issues which required immediate actions. In addition, we provided the customer with detailed information on their existing database system, as well […]
We get it: You’ve been running your SQL Server 2008 for ten years now, and its performance has made you very happy. It’s been as steady as a rock and helped guide your business to success while keeping your data safe. You feel like you really can’t ask for a better show from your database software. Unfortunately, it’s now reached the end of its support life, and that means you’re about to have a whole new range of problems and issues. […]
A leading provider of business management solutions currently hosts many of their workloads using SQL Server databases on Azure. They faced a number of SQL Server database performance issues and needed an efficient solution to resolve them. Having analyzed the customer’s system, we delivered instructions with detailed descriptions of all discovered issues and approaches to fix them. With our instructions, our customer achieved more than three times better overall query performance. Check out our eBook on how we made this happen.
A leader for a customer-to-customer platform for selling and buying old stuff managed a 6-terabyte database using an early version of Amazon RDS PostgreSQL version 9.3. With the gaining popularity in their platform, they needed a way to scale performance and the size of the database near term to 15-terabytes. The main challenge was that the downtime could not exceed 6 hours. Simple tasks like adding a column to their huge table resulted in locking the table longer than the […]