A new inspiring idea exploded in your mind. And you believe the idea has potential and deserves to be put into action. You want the world to see it, and you can even imagine the way this idea transforms into a software solution. Or maybe you already have the solution, and you want to modify or improve it. Finally, you might have your enterprise-level business blooming, but you require specialized engineers to make it more cost-effective.But where do you start? […]
Talks on Managing Data and Applications Anywhere
In Oracle, you can specify virtual columns in a table definition. However, when migrating your Oracle database to Microsoft SQL Server, you need to utilize computed columns. You may want to use SSMA to automate the conversion. The problem is that SSMA does not correctly convert source Oracle virtual columns to SQL Server. So, you will need to update the converted code manually.
Read this blog post to discover our proven solution to Oracle virtual columns conversion to Microsoft SQL Server.
The question of what cloud platform to choose for building an application confuses almost 90% of our startup customers. In all fairness, there are many players on the market of cloud vendors and many options they offer. If we had a proven solution of which cloud you should choose when you have a business in a specific field, a list of countries to release in, and a set of features to implement, then we would share it. However, we should […]
We continue our blog post series that cover the key Database Compare Suite features. In our previous blog posts, we talked about validating data migration and discovering exact data differences in selected tables. Now, we want to talk about comparing huge data assets.
You can use Database Compare Suite to quickly verify migration of extremely huge tables. Read this blog post to discover how you can do this with the fast data comparison operation in Database Compare Suite.
DB Best has successfully completed several Oracle Forms modernization projects, making our customers happy with the new web architecture of their solutions. However, the first question that we regularly hear from our customers sounds as follows. How will the converted web application interact with the database?
Read the blog post to discover the DB Best approach.
Our customer’s data science team needed to perform read-only data warehouse queries against a mission-critical online transaction and batch processing database. They were performing read-only queries over 4 terabytes of historical data. These queries are ad-hoc and look at multiple months of historical data for analysis. The queries would consume all available I/O on the production databases environment and impede the performance of the primary workload. This blog talks about how we helped them solve this problem.
One of the customers contacted DB Best to help address performance issues with their SQL Server application. They started experiencing problems after upgrading from SQL Server 2008 R2 up to SQL Server 2016. However, after we analyzed their database system, we discovered a complex issue with updating SQL Server statistics.
We utilized industry best practices and internal expertise to correct issues. Read our blog post to learn how we approached this complex task.
We continue our blog post series that cover the key Database Compare Suite features. In our previous blog post, we talked about validating data migration. We discovered that several tables are different. Now, we want to see the exact data differences. Read the following blog post to see how simple this is with Database Compare Suite.
In Oracle, you can use a combination of a trigger and sequence to generate unique values for the key columns. However, when migrating your Oracle database to Microsoft SQL Server, you need to find the right path to convert this construction. This is an architecture-level decision, so you need to approach it at the very beginning of your migration project. Otherwise, you will need to recreate tables, reload data and recreate backups, and even rewrite code that relates to these tables.
Read this blog post to discover our proven solution to Oracle sequences conversion.
At DB Best, we believe our Database Compare Suite is the ultimate solution for database developers, administrators, quality assurance, and DevOps engineers to simplify their daily routine. Until we have Database Compare Suite on every developer’s desktop, we are starting a series of mini-blog posts with short videos to hopefully convince you that you can’t live without our Database Compare Suite!
In our first blog post of the series, we will show how you can use Database Compare Suite to validate database migration.