Detailed data comparison
Detailed data comparison with Database Compare Suite
13 Aug 2019

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. Check out our video to see how simple this is with Database Compare Suite. As you can see, Database Compare Suite allows for identifying data differences in 2 tables. Using the detailed data comparison operation, you can discover the […]

Data comparison
Comparing data in your databases using DB Best Database Compare Suite
09 Jul 2019

Subject/Title: Data comparison — regular and detailed / Comparing data in your databases using DB Best Database Compare Suite Type of Content: A blog post that starts a series of articles that cover the key features of the DB Best Database Compare Suite. Target audience: Database Administrators, Database Developers, IT professionals (candidates to join DB Best). Summary of Content: Highlight one of the Database Compare Suite features. I plan to publish these blog posts on a weekly basis. We start […]

Database Compare Suite 4.14
Database Compare Suite update 4.14 brings Amazon DynamoDB support
02 May 2019

DB Best announces the release of a new version of an ultimate DBA tool Database Compare Suite. The latest version supports Amazon DynamoDB. This is the second NoSQL database platform supported by DB Best Database Compare Suite to complement the recent addition of support of Apache Cassandra as a source and target. In addition to this, Database Compare Suite update 4.14 brings the ability to use SSL to connect to Microsoft SQL Server and Oracle databases. Continue reading to learn more […]

convert Oracle synonyms to PostgreSQL
How to convert Oracle synonyms to Amazon RDS for PostgreSQL
08 Apr 2019

One of our ISV customers wanted to get off their expensive Oracle licenses and develop a cloud-based SaaS solution. They looked to us to help their development team migrate their database applications to Amazon RDS for PostgreSQL . The DB Best migration team utilized AWS Schema Conversion Tool (SCT) to automate the conversion of customer’s database and application code. However, the original system utilized a lot of specific Oracle features, for example, synonyms. SCT does not convert all types of Oracle synonyms […]

Fail fast while you can! Don’t let your design process doom your start-up idea
11 Feb 2019

There are a few more exciting things in life than creating something from nothing, watching your hard work evolve from an idea into a product. Seeing people hold in their hands something that, only a short time before, was just a thought in your mind. As you set yourself down to build your first application, you’re walking the path of those that have helped revolutionize our world. From Facebook to Uber, Tinder to Twitter, you’re part of a small group […]

Database Compare Suite 4.13
Database Compare Suite update 4.13 brings Apache Cassandra support
17 Jan 2019

We’re happy to announce the latest groundbreaking release of DB Best Database Compare Suite. The new version allows for working both with NoSQL and SQL-based databases, comparing data between them. In addition to that, Database Compare Suite update 4.13 brings several important improvements and bug fixes, including: Added the support for Apache Cassandra Provided the search option for database objects Updated the data operation properties Continue reading to discover all of the major improvements implemented in Database Compare Suite 4.13. […]

An automated solution for Crystal Reports conversion from Oracle to SQL Server
13 Aug 2018

One of our customers decided to modernize their Oracle database to Microsoft SQL Server. However, the thousands of SAP Crystal Reports connected to their existing Oracle database presented a huge challenge to their migration effort. They reached out to DB Best to develop an automated way to convert all of the connection information from Oracle to SQL Server and, more importantly, develop an automated solution that can extract the Oracle PL/SQL statements in the reports, convert them to SQL Server […]

Faster, Cheaper, Better: Upgrade SQL Server 2008 NOW
17 Jul 2018

So Long, Microsoft SQL Server 2008 I think that you’re supposed to know when it’s time to say goodbye. – Judy Sheindlin 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 while keeping your data safe and you really can’t ask for a better show from your database software. Unfortunately, it’s now reached the end […]

migrating PostgreSQL to Amazon RDS Aurora
Improve PostgreSQL Performance 12X by Migrating to Amazon Aurora with Minimal Downtime
17 May 2018

An online marketplace company managed a 6-terabyte database using an old version of Amazon RDS PostgreSQL version 9.3. With the gaining popularity of their platform, they needed a way to scale the performance and size of their database near term to 15-terabytes. They also had several performance issues including a daily batch script that was taking almost 2 hours to complete that was starting to exceed the maintenance window, and simple tasks like adding a new column to their largest […]

Database Compare Suite 4.12 update brings some important improvements
20 Feb 2018

We’re happy to announce the latest release of Database Compare Suite 4.12. This new version brings several important improvements and bug fixes, including: Improved User Interface Increased Application Performance Functional Innovations Continue reading to learn more about the ultimate DBA tool and discover all of the major improvements implemented in this latest application release.