13 February, 2017
DB Best Event Workshop in Nashville, TN: Modernize data platforms w/ Microsoft Azure and Power BI on Feb 27, 2017
For our friends in the Nashville, TN area, we are putting on a FREE Data Platform on Azure workshop with HOLs on Monday, February 27 starting at 8:30 am at the Microsoft Office. Come join us and learn how to modernize your data platform with Microsoft Azure & Power BI. With the advancements in data transformation, storage, and analytics tools, it’s easier than ever to run production and mission-critical workloads on the Azure platform. Azure is ready to guide you to the future of data analytics. Breakfast and lunch are included, and one lucky attendee will win a free Microsoft Windows tablet! Register Here.
28 January, 2017
We are proud to announce the new version of the Database Compare Suite version 4.6 with support for Teradata databases. Database Compare Suite now has support for 9 total databases including Amazon Redshift, Microsoft Azure SQL Database, IBM DB2, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Sybase ASE. This means that there are 45 pairs of databases available for homogenous and heterogeneous database operations. These operations include schema and data comparison, migration, and synchronization.
Introducing Fast Data Compare
Database Compare Suite version 4.6 now includes a feature we call Fast Data Compare. We designed Fast Data Compare to dramatically improve performance up to 330 times faster for comparing the data in two tables to confirm data migration. After performing a large data migration from one data warehouse fact table to a new table on the same or different database platform, it is not enough to just make sure the row counts are the same on both sides. You need a tool that can rapidly confirm the transfer of your critical data. Fast Data Comparison uses a checksum algorithm with a hash function for lightning fast confirmation against tables with huge amounts of data.
The fast data comparison operation will not show the number of differences (if the compared objects are not equal), or display the exact rows, where the differences are. For these cases, you must use the Data Comparison and Detailed Data Comparison operations. But if we are talking about migration validation for big data volumes, the above-mentioned operations may work pretty long. Fast Data Compare dramatically reduces the comparison time. For example, we tested Fast Data Comparison and the regular Data Comparison operations on a table with 600 million rows. The first operation finished in just over an hour, and the second one lasted for 2 weeks! This is a 330x boost in performance! For smaller tables the difference is not as spectacular. In our test comparing two tables with 1 million rows, Fast Data Comparison completed in 11 seconds versus 70 seconds for a 7x boost in performance.
The Database Compare Suite tool is the DB Best’s ultimate solution dedicated to database administrators and developers for comparing and synchronizing schemas and data along with many migration possibilities between homogeneous and heterogeneous database environments.
Download our free trial from the Database Compare Suite page.
11 January, 2017
We would like to thank our customers for making 2016 a fantastic year for DB Best. Thanks to your trust and the increased number of engagements our business has grown by 70% in one calendar year all along. To meet our customers' needs and maintain our high performance standards DB Best global team has reached over 300 employees worldwide. We are looking forward to a productive 2017, and wishing everyone an amazing year ahead! Check out DB Best's 2016 Infographic for the summary of our achievements in 2016.