5 essentials to learn about your data platform with DBMSys
28 Sep 2016

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 data over time needed to make informed business choices on current and future plans for scalability, flexibility, and increased...

Troubleshooting database migration issues using AWS Schema Conversion Tool Assessment Report
27 Sep 2016

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 determined the target database type, the goal of the assessment report is to examine all issues that the Sche...

Optimizing your SQL Server upgrade projects with Database Compare Suite
20 Sep 2016

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 SQL Server is a great tool to optimize your SQL Server 2005 upgrade projects, and it can identify and synchronize schema and data drift between test and production databases. ...

Selecting target database type for migration using Assessment Report in AWS Schema Conversion Tool
20 Sep 2016

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 allows you to estimate the amount of work to be done, but also helps you compare the complexity of migrating a database into different targets (for exampl...

SSMA for Oracle 7.0 — What’s New — Using Row-Level Security in SQL Server 2016
15 Sep 2016

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, correctly converting it into Row-Level Security in SQL Server 2016 and Azure SQL Database. Background on SQL Server Row-Level Security and Oracle Virtual Privat...

AWS Schema Conversion Tool: Connecting to Oracle Source Database
13 Sep 2016

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 reading the system dictionary with implicit or explicit grants to SELECT_CATALOG_ROLE and privileges for SELECT ANY DICTIONARY. The following video demonstrates the con...

SSMA for Oracle 7.0 — What’s New — Migrating to SQL Server 2016 Temporal Tables
02 Sep 2016

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. Background on SQL Server Temporal Tables and Oracle Flashback Data Archive SQL Server 2016 system-versioned Temporal Tables provide information about data s...