Blog

We are proud to announce the latest version of the Database Compare Suite tool, which now adds support for Amazon Redshift and SQL Server 2000. For customers looking to upgrade their SQL Server 2000 database servers, Database Compare Suite is the only tool on the market that supports comparing database schema and data changes with newer versions of SQL Server. This a great timesaver for your upgrade projects! Eight database dialects are now supported in Database Compare Suite. They include: […]

This continues our video blog series on the AWS Schema Conversion Tool (SCT). We will demonstrate how the AWS SCT helps users convert data and code objects from Oracle database to AWS RDS for MySQL, Amazon Aurora or PostgreSQL database. Background Converting Objects is one of the most important aspects in the AWS Schema Conversion Tool application. The AWS Schema Conversion Tool allows users to convert all objects in the database, or simply select the required objects and convert them […]

A leading provider of content services for the legal industry looked to DB Best to help them modernize their aging Sybase ASE and IQ solutions that were built on top of an old IBM AIX system. We helped our customer in the past with a Sybase ASE migration. The challenge for this project — migrate Sybase Java applications along with the associated Sybase ASE and IQ database solutions to SQL Server. In this video blog post, we’ll discuss the process we […]

DBMSys is a lightweight tool designed by DB Best specifically around collecting data from multiple environments to help develop a business case for a modernization to upgrade path. The Microsoft MAP Toolkit is good for scanning systems and providing a snapshot of some system metrics, but doesn’t provide data over time to understand peak workload requirements and storage capacity needs. DBMSys turns monitoring on its head. Not only does DBMSys help with monitoring your environment for capacity needs, it provides […]

This continues our video blog series on AWS Schema Conversion Tool. In our previous blog post Selecting target database type for migration using Assessment Report in AWS Schema Conversion Tool we talked about multi-platform Database Migration Assessment Report, which helps users to select the target database type depending on the complexity of migration and thus simplify the database migration process. And now we’ll concentrate on using the Assessment Report inside the AWS Schema Conversion Tool application. Background Once you have […]

Often at DB Best as part of our SQL Server 2005 upgrade efforts, a complex upgrade can sometimes take weeks to move into production. During that time, a DBA or application developer may make a change to the older production database without letting the upgrade team know. We like to call this schema or data drift. Originally created for database migration projects, we’ve created Database Compare Suite at DB Best to solve the problem of drift. Database Compare Suite for […]

This continues our video blog series on the AWS Schema Conversion Tool. This post covers one of the key features of the application: the Database Migration Assessment Report. The Assessment Report in the AWS Schema Conversion Tool displays all issues that occur during a database migration process. One of the big things about the report is that it can help you select the optimal target database for conversion. At the same time, the multi-platform Database Migration Assessment Report not only […]

This continues our video blog series about new features, that are implemented in the new version of SQL Server Migration Assistant 7.0. And now we will talk about some important security issues. Row-Level Security (RLS) enables customers to control access to rows in a database table based on the characteristics of the user executing a query. The feature was introduced in SQL Server 2016. Starting from the 7.0 version the SSMA tool can handle Oracle VPD Policy and DB2 access controls, […]

In this video blog post, we will walk through the various Oracle database connection options using the AWS Schema Conversion Tool as the source database. The AWS Schema Conversion Tool only allows the use of an Oracle database as a source. In addition, you will need a user account that has sufficient access rights to read the metadata for objects in the database. Specifically, the user needs the following system privileges: connecting to the database using the CONNECT role and […]

The new version of SQL Server Migration Assistant (SSMA) 7.0 now supports direct migration to several new features introduced in SQL Server 2016. One of these new features is the direct support for migrating Oracle Flashback Archive tables to Temporal Tables. This is very important because earlier versions of SSMA attempted to partially migrate Flashback Archive tables to normal tables in SQL Server and left it up to the user to manually implement the behavior with a relatively high cost. […]